correct way to create mysql table for multiple languages

general

forum:richardvc 13 years ago

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

forum:Guspaz 13 years ago

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

Description

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

Compute

Storage

Networking

Databases

Services

Developer Tools

Industries

Pricing

Community

Engage With Us

correct way to create mysql table for multiple languages

1 Reply

Reply

Tips: