I'm building a chat application in which I'll be using emoticons, so the problem is that when I enter and send the text, for eg. -  "Hahha this is so funny 😂" In MySQL, it gets saved as "Hahha this is so funny ??"  Can anyone tell me how to detect whether the string being saved to server contains an emoji and if it does, then accordingly convert the emoji part to special unicode format?  Thanks a ton!
326
I'm setting up a new server and want to support UTF-8 fully in my web application. I have tried this in the past on existing servers and always seem to end up having to fall back to ISO-8859-1.  Where exactly do I need to set the encoding/charsets? I'm aware that I need to configure Apache, MySQL, and PHP to do this — is there some standard checklist I can follow, or perhaps troubleshoot where the mismatches occur?  This is for a new Linux server, running MySQL 5, PHP, 5 and Apache 2.
64797
Situation: It started out as me  for the literal string C-c in  but it ended up omitting the - sign and showing results which contained the strings C/C++ and C &amp; C++.  is an example of a post which contains that string of characters (yet fails to show up in the results).  Things I've tried:   post suggests that I can use the undocumented code: operator, but when I do that, it just wraps the whole term in double quotes like .  As @terdon in Unix &amp; Linux chat has , using this  does yield some relevant results, but it doesn't show me  that is supposed to be there. edit: It appears that the Symbolhound query no longer returns that result.  Finally,  says that you can search for literal characters, but as you can see:    Quoted phrases are exact matches except for case-sensitivity, for example, you can search  or .  The second example (symbols) leads to 0 results.  So by now I assume that the search engine has changed (but the old documentation still lingers on this site). Is there a method for me to search for strings that include special (or is it literal?) characters?
40591
For example,  when displayed in the Android app doesn't show the ǝ character properly  in the username:    This happens in their profile and on posts.  Android app version 1.0.18 on Samsung Galaxy S3 and Android version 4.1.2.
12796
When I open the file in Vim, I see strange ^M characters.  Unfortunately, the world's favorite search engine does not do well with special characters in queries, so I'm asking here:   What is this ^M character? How could it have got there? How do I get rid of it?
87331
When I Import Mysql from local server to web ser it is showng me error 1115 - Unknown character set: 'utf8mb4' in Creating wordpress wp_comment table CREATE TABLE IF NOT EXISTS  `wp_commentmeta` ( // // ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT =1;  #1115 - Unknown character set: 'utf8mb4'  My mysql version is Version information: 4.0.4, latest stable version: 4.4.10 (local version)  Version information: 4.0.10.7, latest stable version: 4.4.10( server version)  Please help me to solve out the error
16453
Friends, sometimes I had to create a self-contained PHP script. That means the PHP script could have any files within it due to some encoding/decoding algorithm, like Base64. For example,  is a Base64 encoding of this tiny image:   Of course, in this particular case, PHP can handle that huge encoded string because it has a bundled  function.  I was wondering if this idea is possible to achieve somehow in TeX/LaTeX. I need to point out that I'm just curious on this subject, not that I want to embed whatever in code. Besides, as you noted, the encoded string is huge, so that'd surely make people cry blood.  One possible solution I see is if somebody implement an encoding/decoding algorithm in TeX/LaTeX, like \base64_decode, so it would be possible to use something like this: \includegraphics{\base64_decode{\myhugeunreadablestring}}. Sorry for the acid trip ticket, but I'm really curious on how this insane code would work. =)
10708
Some questions, for example    Instead of using a correct URL, such as  http://meta.stackexchange.com/questions/79543/٩●̮̮̃-̃۶-forbid-unicode   are using  https://superuser.com/questions/516363/what-is-the-��-character   What is causing this behavior?
108363
I have an UTF-8, polish text in .tex file. When I open it with my LEd (LaTeX editor), it shows ok (all characters can be seen). But when I try to compile it, I get error:  Package inputenc Error: Keyboard character used is undefined (inputenc) in inputencoding `utf8'.   I have to copy the text, cut it and paste to Notepad++, change (not convert!) encoding from UTF8 to ANSI (the polish characters will be missed and replaces with some random characters). Than copy it again and paste to LEd (in that editor, characters display bad also). But now I can compile my pdf and in it, the encoding is right again.  Is there a way to set encoding in the way I will see characters in LEd propertly and I will be able to compile it and I will get good characters in pdf?  The begging of my code:  \documentclass[12pt]{report} \usepackage[T1]{fontenc} \usepackage[utf8]{inputenc} \usepackage{graphicx} \usepackage{amsmath,amssymb,amsfonts} \usepackage{txfonts}
52656
How can I use/display characters like ♥, ♦, ♣, or ♠ in Java/Eclipse?  When I try to use them directly, e.g. in the source code, Eclipse cannot save the file.  What can I do?  Edit: How can I find the unicode escape sequence?
100873
Safari 12.0 macOS Mojave version 10.14 MacBook Pro (13-inch, 2017, Four Thunderbolt 3 Ports)  AS of today (2/11/2018) characters in Safari are being shown as boxed question marks.  The same websites are displayed perfectly in Firefox.  Emojis are not displayed in Messages main window but in the sidebar they are!  I have tried restore default fonts etc but no difference.  Any help appreciated.
115935
I have a form with a textarea. Users enter a block of text which is stored in a database.  Occasionally a user will paste text from Word containing smart quotes or emdashes. Those characters appear in the database as: â€“, â€™, â€œ ,â€  What function should I call on the input string to convert smart quotes to regular quotes and emdashes to regular dashes?   I am working in PHP.  Update: Thanks for all of the great responses so far. The page on Joel's site about encodings is very informative:   Some notes on my environment:  The MySQL database is using UTF-8 encoding. Likewise, the HTML pages that display the content are using UTF-8 (Update:) by explicitly setting the meta content-type.  On those pages the smart quotes and emdashes appear as a diamond with question mark.  Solution:  Thanks again for the responses. The solution was twofold:   Make sure the database and HTML files were explicitly set to use UTF-8 encoding. Use htmlspecialchars() instead of htmlentities().
4554
How do I post text so that it is formatted as code?  What do I need to do so that my code shows up properly &mdash; not escaped or removed &mdash; when posted? And how to get the correct syntax highlighting?     For more information, see "" in the .
120005
I am looking for a canonical question and answer on this issue.   (see ) on  has prompted me to ask this question.        In all honesty I think we just don't need a comic strip to explain what a user is saying. Currently I edit out emoticons I see, but this post presents a whole new type of .... ? what I'm not sure.  Is there are community consensus on this either way?  These questions are related — but different:        Please try and answer sensibly (rolls eyes at the prospect of a flood of emojis in answers) — so we can actually have something that we can link to new users (or old users) when editing this stuff out — or (even worse), defending its existence.
103530
I'm wondering if there is a "best" choice for collation in MySQL for a general website where you aren't 100% sure of what will be entered? I understand that all the encodings should be the same, such as MySQL, Apache, the HTML and anything inside PHP.  In the past I have set PHP to output in "UTF-8", but which collation does this match in MySQL? I'm thinking it's one of the UTF-8 ones, but I have used utf8_unicode_ci, utf8_general_ci, and utf8_bin before.
30050
I am aware that this might not be the ideal place please move/close this if so.  So since yesterday I run into the following problem:  I use \usepackage[T1]{fontenc} and \usepackage[utf8]{inputenc} in the preamble and save the document in TeXShop accordingly as a UTF-8 encoded file.  As soon as I close the document and open it anew the document is now of type applemac and obviously the special characters are all different. Now this only seems to happen for new document because I wrote my thesis with the same preambel and there when I open it it is still a UTF-8 encoded document.  I really have no idea what's going on. Has anyone ever experienced something similar?
48211
Im using smarty and mysql_real_escape_string() for user input, and when I insert some code with ' or " , and lookup in phpmyadmin it shows without backslashes.  When I get record from DB i doesn't have backslashes also. But when I just pass escaped string without inserting into the db it is backslashed.  Shouldn't it add slashes, insert with them and then I would  strip them when i would output? Or am I missing something?
99906
One of the responses to  suggested that I should make sure my database can handle UTF-8 characters correctly. How I can do this with MySQL?