Re: Support for multiple languages in a single MySQL DB
Posted by: Peter Gulutzan
Date: February 17, 2007 05:32PM

I'll assume you use MySQL 5.0. Most 8-bit character sets for west Europe (e.g. latin1) are good for both English and Spanish, and of course the Unicode character sets (e.g. utf8) are good for English and Spanish and many others. But the default collation differs. If you care about Spanish modern (N-tilde <> N), latin1_spanish_ci is okay. If you insist on Spanish traditional (LL <> L and CH <> C), utf8_spanish2_ci is better.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Support for multiple languages in a single MySQL DB
4127
February 17, 2007 05:32PM


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.