View All Products
Compute
Storage
Networking
Databases
Services
Developer Tools
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ correct way to create mysql table for multiple languages
Log in to Ask a Question

correct way to create mysql table for multiple languages

general

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

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.

Reply

Please enter an answer
Tips:

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] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct