Re: Support for multiple languages in a single MySQL DB

[Peter Gulutzan]

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.