Mysql Character Set
Posted on 2008-10-11
I am working on a project that will require text to be stored in multiple languages:
$language_1 = array("English", "French", "German", "Portuguese", "Spanish", "Swahili");
$language_2 = array("Russian", "Mandarin", Arabic");
I believe the choice of "latin1" character set & "latin1" collation will work for the languge_1 options. But what about language_2? Is there any way those langages can be stored in the same database or will it require a completely separate set of databases with a different character set and collation properties?
The specific application is that a user arrives at a home page where they are given the option of choosing the language in which they would like to read the instructions. Once they choose, the welcome letter is displayed on the screen and in the language they selected. They then continue to a form where they fill out their personal info. This form again is in their langague. The info they enter must then be stored in a database in the language in which they are working.
So, for example, can the Russian and Spanish text share the same database or must there be two separate databases, each with their own character set? Or is it possilble to have a default character set but then an override for a specific row of a table?