correct way to create mysql table for multiple languages


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.



1 Reply

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.


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct