StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>A few of things to check:</p> <ol> <li><p>Make sure your tables and text fields really accept utf8:<br> Use the <a href="http://dev.mysql.com/downloads/gui-tools/5.0.html" rel="nofollow noreferrer">MySQL Query Browser</a> and try to edit some data manually.<br> If it stays OK once you saved your edits, then the fields and tables are correctly set.</p></li> <li><p>Make sure that you are actually inserting utf8 compliant-characters and not characters based on another form of encoding such as GB2332 for Chinese.<br> If that's the case, you may need to convert the strings to utf8 before you can send them to the database.<br> You can have a look at using the <a href="http://msdn.microsoft.com/en-us/library/system.text.encoding.aspx" rel="nofollow noreferrer">Encoding</a> class in .Net.<br> I've <a href="https://stackoverflow.com/questions/379191/convert-gb2312-to-utf-8">answered a post</a> on something related a while ago and there is a <a href="http://www.codeproject.com/KB/aspnet/Encoding_in_ASPNET.aspx" rel="nofollow noreferrer">CodeProject article</a> on just this issue.</p></li> <li><p>You probably also need to make sure that the <a href="http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-without-dsn.html" rel="nofollow noreferrer">ODBC connection string</a> includes the following:</p> <p>CharSet=utf8;</p></li> </ol> <p>There is a <a href="http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html" rel="nofollow noreferrer">list of all the parameters</a> you can use for the ODBC conection.</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