StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I can't answer the question of it being listed as both supported and unsupported, that's probably a question for the people running the fileformat.info site.</p> <p>UTF-8 can be used to represent <em>any</em> Unicode character (code point). This is true of all of the UTFs. The number of bytes required to do so varies (in UTF-8, you need four for the code point you identified, for instance, whereas you only need one for the Roman letter 'A'), but all Unicode characters can be represented by all UTFs. That's what they're for. (<a href="http://www.unicode.org/faq/utf_bom.html" rel="nofollow noreferrer">More here</a>.)</p> <p>It sounds as though you're running into an encoding problem at one (or more) of the layers in your app. The first place to look would be the page served by your app: Does it say what charset it's using? It may be worth checking the headers being returned for your pages to see if they have:</p> <pre><code>Content-Type: text/html; charset="UTF-8" </code></pre> <p>...in them. If they don't, look for the equivalent <code>meta</code> tag in the HTML itself, though I seem to recall reading that <code>meta</code> isn't a good way to do this. Absent the headers being specific, the default applied will probably be <a href="http://en.wikipedia.org/wiki/ISO/IEC_8859-1" rel="nofollow noreferrer">ISO-8859-1</a> (though some browsers may use <a href="http://en.wikipedia.org/wiki/Windows-1252" rel="nofollow noreferrer">Windows-1252</a> instead), which won't work if your source text is encoded with UTF-8.</p> <p>The next place to look is your database. I don't think MySQL stores text in UTF-8 by default, you'll need to ensure that it's doing that in your MySQL configuration.</p> <p>From your question, I don't think <em>you</em> need it, but I'll finish with the obligatory plug for the article <em><a href="http://www.joelonsoftware.com/articles/Unicode.html" rel="nofollow noreferrer">The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)</a></em> by Joel Spolsky (if only to save someone from plugging it in a comment). :-)</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload