Re: Storing UTF-8 strings in MySQL Database
Posted by:
Rick James
Date: March 21, 2009 02:33PM
Strings are converted going into and out of MySQL server from the client. In many situations, SET NAMES is required. One can hope (I don't know) that JDBC declares what the client encoding is (UCS-2?).
It is generally agreed that the 'best' all-around settings for multi-lingual MySQL is utf8, with utf8_unicode_ci (not utf8_general_ci).
If you are mono-lingual, other encodings and/or other collations may suit your application better.
Subject
Views
Written By
Posted
9198
March 20, 2009 12:04PM
Re: Storing UTF-8 strings in MySQL Database
3508
March 21, 2009 02:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.