Let me explain my problem. On my site, currently my emojis are well displayed, however, on the future version I'm developing, there are the &quot;?&quot; problems when I use the same database (with utf8mb4_general_ci). Is there a PHP alternative to debug this? Thanks,
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.
107259
I have been dealing with this problem some days. Maybe you can help me? When running pdflatex I get this error:  ! Argument of \UTFviii@three@octets has an extra }. &lt;inserted text&gt; \par l.15 I've run across a `}' that doesn't seem to match anything. For example, `\def\a#1{...}' and `\a}' would produce this error. If you simply proceed now, the `\par' that I've just inserted will cause me to report a runaway argument that might be the root of the problem. But if your `}' was spurious, just type `2' and it will go away. Runaway argument?   Minimal Working Example  \documentclass[12pt,twoside]{report} \usepackage[spanish]{babel} \usepackage[utf8]{inputenc} \usepackage{fancyhdr} \pagestyle{fancy} % no recuerdo para que era fancy \usepackage{csquotes}  \usepackage[backend=biber]{biblatex} \addbibresource{bibtex.bib}  \begin{document} \cite{klamt1993cosmo} \cite{quantum-continuum-tomasi2005}  \cite{tomasi-PCM1981}. \printbibliography  \end{document}   The bib file i am using is:  % This file was created with JabRef 2.10. % Encoding: UTF-8  @Article{klamt1993cosmo,   Title                    = {COSMO: a new approach to dielectric screening in solvents with explicit expressions for the screening energy and its gradient},   Author                   = {Klamt, Andreas and Sch{\"u}{\"u}rmann, GJGJ},   Journal                  = {Journal of the Chemical Society, Perkin Transactions 2},   Year                     = {1993},   Number                   = {5},   Pages                    = {799--805},    __markedentry            = {},   Publisher                = {Royal Society of Chemistry} }  @Article{tomasi-PCM1981,   Title                    = {Electrostatic interaction of a solute with a continuum. A direct utilizaion of AB initio molecular potentials for the prevision of solvent effects},   Author                   = {Miertu{\v{s}}, S and Scrocco, E and Tomasi, J},   Journal                  = {Chemical Physics},   Year                     = {1981},   Number                   = {1},   Pages                    = {117--129},   Volume                   = {55},    Publisher                = {Elsevier} }  @Article{quantum-continuum-tomasi2005,   Title                    = {Quantum mechanical continuum solvation models},   Author                   = {Tomasi, Jacopo and Mennucci, Benedetta and Cammi, Roberto},   Journal                  = {Chemical reviews},   Year                     = {2005},   Number                   = {8},   Pages                    = {2999--3094},   Volume                   = {105},    Publisher                = {ACS Publications} }   I can not change this file, any change I make jabRef return them in this way again.  Only for it helps, I have download all packages (texlive, biber 1.9, texmaker) from promt, and I am using Debian.  When I remove \printbibliography errors are gone (but I need to print it)  Any idea of what is going on?  EDIT i do not know if it is an answer but changing to biblatex it works.
118687
Just yesterday, I installed the  (fonts-emojione-svginot) for Ubuntu via the Launchpad PPA method. On the , all the emoji display in color on my laptop.    But emoji like 😂 (tears of joy) show up as their black and white counterparts rather than their EmojiOne counterparts in Firefox. On Chrome, all emoji show up as black and white icons.  Firefox:    Chrome (demo page):    Why is it that Firefox will display some emojis in colour, but other emojis in black and white? In Unity Tweak Tool, my default font is set to Bitstream Vera Sans Roman (I have no other types of Bitstream Vera fonts), which is said to display EmojiOne. My document and window font is set to the same one. Only my monospace font is different (Courier). In Firefox's about:config, I have "gfx.font_rendering.fontconfig.fontlist.enabled" set to "false". Also, my Serif and Sans-serif fonts are both set to Bitstream Vera in Firefox.  I've also noticed that sometimes my fonts will switch to DejaVu Sans. Why? Why can't I set my fonts to a Bitstream font permanently?
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.
3307
I'm having some problems with listings and UTF-8 in my document. Maybe someone can help me? Some characters work, like é and ó, but á and others appear at the beginning of words...  \documentclass[12pt,a4paper]{scrbook} \KOMAoptions{twoside=false,open=any,chapterprefix=on,parskip=full,fontsize=14pt}  \usepackage[portuguese]{babel} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{listingsutf8}  \usepackage{inconsolata} \lstset{     language=bash, %% Troque para PHP, C, Java, etc... bash é o padrão     basicstyle=\ttfamily\small,     numberstyle=\footnotesize,     numbers=left,     backgroundcolor=\color{gray!10},     frame=single,     tabsize=2,     rulecolor=\color{black!30},     title=\lstname,     escapeinside={\%*}{*)},     breaklines=true,     breakatwhitespace=true,     framextopmargin=2pt,     framexbottommargin=2pt,     extendedchars=false,     inputencoding=utf8 }  \begin{document} \begin{lstlisting} &lt;?php  echo 'Olá mundo!'; print 'Olá mundo!'; \end{lstlisting}  \end{document} \end{lstlisting}
72122
This issue occurs when I attempt to post the Chinese characters for the novel "Water Margin" 《水浒传》 as a quote on Mythology SE. The error occurs even if a single character 水 is posted. The question referred to is .   However, this bug does not seem to occur on Meta SE, so it doesn't appear to be a SE-wide bug, but one that is confined to Mythology SE (and possibly other sites).   An image is attached of the error:
17694
I can read the MySQL documentation and it's pretty clear. But, how does one decide which character set to use? On what data does collation have an effect?  I'm asking for an explanation of the two and how to choose them.
116891
Today I found my first ever (to the best of memory) emoji in a post.        Having no idea this was even possible I came here looking for some history. I found there is an  tag. There seems to be consensus that they add little to no value on SE per  &amp;  we also know they don't translate well on all devices    I don't find any history other then this one post  where there is any focused attempt to support them. I don't find any history of discussion on supporting them.    Two questions   Is it possible to disable emojis across Stack Exchange?   If yes   Should we disable emojis across Stack Exchange?
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
114665
When I want to execute a php file it's displayed as text in my browser.  I have a VPS at Hostinger I installed Ubuntu 18.04 with Webmin and LAMP(installed automatically).  I checked the installation see below.  apache2 - v and php -v gives me: Apache/2.4.29 and PHP 7.2.24-0ubuntu0.18.04.6  So everything seem to be installed correctly.  My default folder is /var/www/html/ I do not us short tag in my code.  I try to lunch a file called phpinfo.php with content:  &lt;?php phpinfo(); ?&gt;   And plain text appear on the page.  If the file begin with html code it's correctly rendered, even with a .php file. But the php part is not executed. e.g:  &lt;!DOCTYPE html&gt; &lt;html lang="en" dir="ltr"&gt;   &lt;head&gt;     &lt;meta charset="utf-8"&gt;     &lt;title&gt;&lt;/title&gt;   &lt;/head&gt;   &lt;body&gt;     &lt;h1&gt;Hello&lt;/h1&gt;   &lt;/body&gt; &lt;/html&gt;  &lt;?php phpinfo(); ?&gt;   Render :  Hello  But  &lt;?php phpinfo(); ?&gt;  &lt;!DOCTYPE html&gt; &lt;html lang="en" dir="ltr"&gt;   &lt;head&gt;     &lt;meta charset="utf-8"&gt;     &lt;title&gt;&lt;/title&gt;   &lt;/head&gt;   &lt;body&gt;     &lt;h1&gt;Hello&lt;/h1&gt;   &lt;/body&gt; &lt;/html&gt;   Render the code as plain text.
118033
Please look at the image. The right column's text jumbles with some comment text when the comment contains a large amount of white-space inside an inline code block. I guess that's not the design may be the comments should be a little bit more restricted from expanding? What do you think?    Now even kinda worse:
117514
contains several lines with inline formatted code. It looks aligned in web:        But it looks like spaces are eaten in the Android app:        Same buggy behavior in iOS app:         And mobile web:         App Version: 1.0.95 Device Manufacturer: LGE Device Model: LG-H860 OS Version: 7.0 (1710300506712)      App Version: 1.7.0.1 Device: Unknown (iPad7,3) / iPad Pro 10.5" OS Version: Version 10.3.3 (Build 14G60)
18413
that I posted on Meta.Programmers was rather broken, with a block quote replaced by apparently random letters and numbers. Aarthi fixed it with a non-breaking space, but I don't understand what went wrong.  When I opened the post for editing, the displayed text was what I intended to go there. It only happens when the post is viewed in the reading mode. The preview also displayed the text correctly.
11265
There are many question about rendering unicode in latex that are subject to interpretation, I would like to ask how to properly render Zalgo text with lualatex (or any other tex; just to specify a focus), that is i want to have this:  T̸̙̖͕͕̣̥͕̙̓̋ͯ̇ͨ̎́̀̚o͎̤͍̠̯̣̦̖̔̈́̚͝ ̗̭͚̲̮͎̝͓ͨͫ̿̍̔͟͠i̳̙̪̙͎̗̠͌͐̃͛̈́ͅn̥͚͇̪̽̅̈́͌͌̀͞v̴͎͖̝̝̯̦̣̪ͩͧ̓ͥ̽̔̎͑͒o͙ͦͭ̀͝k̗̯̥̅̏̈́͑ͪ̋͞e͛ͩ҉̨҉̖͚̙ ̴͕̰̮̲̤͎̬̼ͥ̽̽ͬ̆͆͟t͕̳͈͖̪͍̞̭̐̊ͯͯͩ̇̊́h̰̅ͤ͒̂̄́e̵̯͙̓̾͑̀́ ̢̻͍̣̟͈̍̽͆̑̆ḥ̠̞̺̯ͥ̽̉ͥ̊̃ͨì̡̼̯̹̭̙͉̪̰̄ͤ́v̤̦ͦ̅̽̚͡ͅe̦̯̙̲̪̐̄̅͛ͫ̀̄̇͟͢-̡̘̭̓ͪ͒̄̽m̵̲̺͔̩̅̅̉̓͌̌ị̲̣̮̦͕̝͇̂̉̌ͩ̒̎̊͞n̰̮̦̪͈̩̄͐ͬ̋̈́͂̕͠ͅdͮͧ̊̐͜͏̮̪̰ ̡͚͇͈̙͕̣̲͇ͯͣr̖̎̾͜͝e͑̊̎̈ͧ͌҉̤̫̥p̃̓́͂̈́̈҉̠̻̙̞͓̮̮̙̪r̴̦̭̺̝̤̪̪̗͒ͦͨ͊̆̎̚͘e̶̬͕͗ͭs͍͓̩͊̊̇̾ͬê͏̴̯̩͈̟̮͈̥ͅn͚̜̗͈̫̠̖̗͆͛͡ţ̠̳̩̻̭̿̊̒ͣ͘͢i͚̺̬̳͛̏̉͆ͣ͋̀͞ͅņ̝ͮ̄̕͟ǵ̡̟͈͉̭ͮ̈́̔̆ͣͬ̚͟ ̮̱̯ͮ̌̔̓̈̂ͪͯ̀c̵̵̶͇̙̟͚̪̤͍͖̖̄̃͒͐̃̊ȟ̬̬̦̲̖͙̫̔ͮ̍́a̒̍ͣ̑͂ͭ͏͙̖o̢̖͔̞̫̩͚̗̝ͬ̍̌ͧ͆ͨͨ́s̾ͩ̀̅͐͗ͧͭ͏̜͍͈͓̲̞̦̥.̳̥̱̋̃̊̅̕͘ ̸̢͕̽͗̀ͣ̄̎͆ͨ͞I̢̟̪͎͔̜̥̙̥̬͛ͤͯ͐ǹ̀҉͎͎̜v̷̦̼̙̱̍̋̚o̵̢̪̥͐͛k̸̺͙̲͌́ͅi̛̞̹̹̞̤̭ͬ͛̾̍͑ͥ̑̕͜n̡͖͋͂̿́̕͞ǵͤ͂ͤ̇҉̜͔̱͓̮̜ ̵̴̼̞̟̬͒̽̈́̔̍̎͋̈͗t̡̺͔͚̖̼̺̞̍̔̔̈́̽͟͝h̲́̈̏̃̋͢ę̹̭ͦ̽ͤͭͦͅ ̪͔̜̞̺͓ͤͯͤ́͢͝f͓̮͕͇̼͆ͧ̈́̓͝e̛͍̮͙̼̰͍̜̜̾̂ͭ̀̅͋̈́̓̕e̢̩̫͆͊͟l̵̢̟̥̥̰͓̪̖ͮ̔͋ỉͧ̿̒̿ͩ҉̼͕̫͈n̗͔̩̗͖̳͍̺̱͗̇͗̏͑ͦ̐g̶̥͍̺̰͉͇̘̈ͫ͑̀͡ ̧̹̳̬͇͓̮̜͉͌̊̆͐̈́͊o̩͖̖ͧͩ̔̓̏̇ͨ͒ͩ͘͘f͎̺ͪͨ͊͆͗͒̇ͮ͡ ̨̼̘̭͓̪̉͌̒͒̔͐ͨͅc͕̼͕͂́ḫ̶̮̹̖͙̋̄̑̆̇̉͜͝a̷͕̻̩͉̘͎͑͋̒̕ȏ̢͙͚ͬ͂̿ͭ̎̋̄s̡̍ͫ͐̓̽̀ͨͬ̕҉̹̬̳͉͓̗͔͉̫.̟̙̯̍̈͒ͯ͝ ̠̻̓ͦͪ̀W͙͆̍ͮ̂͆̀̚i̓̄ͦ̋͟͞҉̩͉͚̖t͛̍̾͒ͨͦ̅҉͉̼́h͖͈̲͈̟͚͗̂͋ͤ́͢ ̙͚̙̄͊͝ͅǫ̷̲̖̖̘͋́̈́ù͉̫͔͓͇̇̌͒͒̈ͪ͜t̴̪̀̓ͦ̾̿͘͜ ̰̹͙ͤ͢o̝̝̬̮̥̟̳̍̀̋̇̑ͭͅr̯̟̝̠͍͇̭̤͚ͨͯ̿ͬ̔ͤd̵̘̮͎̖̯͇ͪ̀̐͠e̲̭̲̺̥͍̰͎͆ͫr̡̛̭ͣͦ̋̕.̫͓̯͎ͧ̐̌͑̕͠ ̧̢͚̩̪̦̮̏̍̇ͮ̒T̴̼̼̮̝̉ͬ̍ͤͥ̃̍͡h̴̠̣̙͎͋͐̀̚͠e̛͒͌̍̈́͐͑̆̿͌͏̰̦͖̻̱ ̴̛͈͚͔̊ͨ̀ͩ͝Ņ̸̥͎̄ͧ̚͞e̺͚͈͖̠̘̤̽ͬ̎ͧ́ͭ̚͞z̼̫͓̺̹̮̝̮͗̚͡p̧̨̪̘͛̾̂̿̿ͫͦ̍ę̴͔͓̥̦͔͚̬̔ͧ͌͌ͨ̈́̊ͧͧr̾̈́ͥ͐̄̒̋͐҉̝̮͓̜̕d̷͕͈̥̦̺͔̳̊i̶͙͎̯̜̦̻͊̿̏ͩ͛ã̦̾̓͒̉̚͠ͅn̬̘͙͓̣̓̐̓̈̽̈͐̿ͅ ̷͈̣̲̻̍͒ͣ̉ͩ̔ͩ͘h̾͌͐͏̴͔̫̲̤͙͚̣͉͇ị̳͓͙͖̟̊ͩ́̀v̛͈̜́͗̒̊ͣ̒̋ͬ͟͠ȩ̻̲̺͚̪̹̔̑̇͗ͮͭ̀͝ͅ-̸͎͔̮͈͙̻̝̳̎̈́ͬ͋͋̏̒ͯ̉͢m̳̈̾͋̑ͭ̑̆ͬị̷͕̯ͤ̀͝͡n̯̲͓͂ͪͨ̀ͧ͑͠d̦̤̗̲͈̖̗̹̔ͅ ̨̪̗̣̝͎̺͛͛ͬ̿́̾̅͞o̘̣͇̜̗̞̱͍̓ͅf̲̗̳̟̣́͊͞ ̛͚͙͇̞̱̠ͧͫ̋ͨ͌͌̈́ͭċ̴̨͈͑ͤͣ̐̂͞h͙̃͐ͧ̿͆̂̈̅a͙̲͇͎͈̋̌͐̾ǒ̴̫̯̭̖͎̄̉̈́͛̄́s̗͍͈͙͕̺̲͍̋ͮ͟.̢͙ͭͭͫ͆͞ ͓̼̹ͬͨ͆͂̽̅ͯ͝Ż̸̴̲̯̤̟͈̘̈́̏ͭ͐̓͑̒̀à́͒ͅl̴̛͈̋͌͊̕g͕̤̖̮̾ͪ̏̊͐̎ͦ͘o̧̙̥̤̣ͮ̑̍̆̿̓.̢̙̠͗͌͋͝ͅ ̩̩̲̘͕̣̥͙ͦ̓̄͌ͯ̉̌̉͝͠ ̻̤̰͇̪̈͌͆̽̏ͣ̂̿͟͡H̺̽͌̈́ͣ͌̄e̗̜̜͒͋̂ͮ̉̑̈́̀̚͠ ̻̼͍͎ͧ̈́͝͠w̸̮̺̟̬̎ͫ̄̈́ͤ͂̌ͬ̓͝h̷͈̯̬̪̿̆̈͌͌̊̔̀̚o͆̈́̀ͩ͞͠͏̻̟̜̱̙ ̴̹̻̪̯̭̦͕͉̌̆̽͘W̧̧͔̺̦̯̙͕̾̒ͤ̑̇͞a̡̪̣̺̐͗̅ͩ̋̈́ͦͨ͢ȉ̉͞҉̢̝͉̻̩̹̰̤t̵̛̬̺͖̳̗͉̝̭͍̾̑̿́ͬͪ̂ͤs̴̫̱ͭͫ̆ͨ̈́ ̮͖̲̠̘̩̍̿́̚͡B̢͍̮̬̱̤̫̃ͬ̕ę̣̣̹̑͐̉ͪ̒ͧͅh̶͓̼̘ͭͨͯ̑̅͜ȋ̯͖̦́ͯͣ̿̒̐nͮͣͪͣ̏҉̹̮̩̭d͍̤̦̱͓̹̲͚̄̾̄̏͑̕ͅ ̠̤̿̿̉̍ͫT̾ͯ͏͏̡̣̼͚ͅh̶̹̠͈̗̋ͭͤͅe̘̫͍̮̥ͣͣ̐̂͐ͭ́ ̸͔̲͈̩̟̖̗͖̈̐͞ͅW̴̫̘̺̤̝͈̜̙ͤ̅̔ͩ̈́̑̊a̟̲͖ͤ̈́̂ͦͧͫl̷̥̺̙͎̝̬ͪͦͨ̐̔ͭ̓͐͞l̷̶̟̜̤̤̯̞̦̋ͬ̚.̸̵̜̩̄ͧͪͦ ̑̒͑̋͏̵̼͎̺̼ͅͅZ̡̘̤̮͇̞̪͉̞͐̏ͬͤͭͤͧ̀́Ḁ̪͖͚̫̼͔̼̆̐ͧ̓ͥ̓̓͝L̷͖͈ͪ͂̔̏̆̓̚͜Ģ̵̶̩̔̒ͦ̂̑͋̈́ͅO͊ͯ҉̟̮͇͔̬͉̣͡͡ͅ!̫̭̈́̅̌ͪ̃ͩ̚  in a pdf.  Just copypasting it inside a document does not work. Two possible kind of solution i can imagine would be:   an environment or a package that allow complex composing characters or a way to input a text codepoint by codepoint   In this context i don't care whether symbols like emoticon or flags would work; just really weird looking text.
5341
So WP 4.2 introduced emojis (smileys) that basically adds JS and other junk all over your pages. Something some people may find shocking. How does one completely erase all instances of this?
82276
asked in July explains why it is not possible for the time being to submit content in posts or comments that contains Unihan characters. It’s a spammer thing, fair enough.  As  makes clear, the workaround for posts is to convert your Unihan text to HTML entities: these are parsed and appear correctly.  However, HTML entities are still HTML and as such are not parsed at all in comments, as . In other words, since Unihan glyphs are banned from both posts and comments and HTML entities are not parsed in comments, it seems to be completely impossible to post text containing Unihan glyphs in comments at all, except on sites where the ban has been manually removed, like Japanese.SE.  This seems like a rather substantial limitation. And in any case, the blanket ban on Unihan is unduly heavy-handed and inflexible (not to mention perplexing to the user, when the only feedback you get is “Body/comments cannot contain that content”).  In , tchrist suggested that the ability to post Unihan glyphs could be made a rep-based privilege; that is, a certain amount of reputation is required to include these glyphs, otherwise it fails. A requirement of, say, 125 rep points would presumably cut off at least 99.99% of spammers, and it would have the added benefit of being able to maintain—and broaden—the restriction indefinitely to mitigate spam, while still allowing legitimate users to post relevant content.  (The feedback message would have to be improved as well, though; something like, “Due to large volumes of spam written in certain non-Latin scripts, you need at least 125 reputation points to be able to include non-Latin text in your post” or words to that effect.)  Can this be implemented?  Alternatively, as pointed out in Normal Human’s reply, since comments already require a certain amount of rep meant to deter absolute newcomers (and, by extension, also spammers), can the ban just be removed from comments and applied only to posts?  (Editing this just to bump it on the front page, to hopefully have some kind of discussion or feedback on the matter.)
16133
UPDATE: It turned out to be the Ubuntu font I had applied. I went to the system font and it comes out normal. However, I personally think it would make sense to count the dash as a character and resize the text as if it were three numbers, like the high upvotes.  I guess this question should be closed as non-reproducible, if that's a reason on meta.se.     has the same subject, but the comments say it's been fixed. I am not using the SE app from 2013, but rather the newest version 1.0.85 and since it doesn't happen to others, I assume it's something with my screen size. I also don't see this with positive three character vote counts at all, so it's not really the same thing.    It seems like (at least) answers with a score of -10 or lower cause issues with formatting on mobile.  I took a look at  on Ask Ubuntu using the Android app and saw this:    It seems like there isn't enough room horizontally to display three characters with that font size, so it breaks the third one onto another line.  This issue doesn't show up in highly upvoted questions or answers, as the font size is just lowered to fit:    So it looks like the hyphen isn't counted by whatever chooses the font size, causing the line break.  I'm using Cyanogenmod 13 on a Verizon Note 4 (DPI set to 520), with the Ubuntu Regular font, in case that might be relevant.  I just tested it on an iPad, and the (now) -14 shows up fine, but screen and default font size may have something to do with that: