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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Storing UTF-8 strings in MySQL Database
3515
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.