Linode Forum Index Linode Forum
Linode Community Forums
 


correct way to create mysql table for multiple languages

Click here to go to the original topic

 
       Linode Forum Index -> General Discussion
Author Message
richardvc



Joined: 07 Dec 2010
Posts: 55
Posted: Fri Dec 02, 2011 1:07 pm    Post subject: correct way to create mysql table for multiple languages  
Hi,

I have a text file which has usernames in multiple languages. Fistname and Lastname.

If I want to import that in a mysql table, which charset I should use?

Usernames are in chinese, thai, english etc.

Thanks
Richard
Back to top  
Guspaz



Joined: 26 May 2009
Posts: 1150
Location: Montreal, QC
Posted: Fri Dec 02, 2011 2:45 pm    Post subject:  
utf-8 would be the preferable catch-all. But it's not ideal for CJK (Chinese/Japanese/Korean) display, because of controversies about Han unification. They have specific character sets that are more appropriate for those languages.

I guess the answer is, if you have to support everywhere, use unicode. If you are trying specifically to support one language, use the most appropriate charset for that language.
Back to top  
 
       Linode Forum Index -> General Discussion
Page 1 of 1