MySQL Forums :: Newbie :: Charset and Collation Question


Advanced Search

Charset and Collation Question
Posted by: Dean Richert ()
Date: November 15, 2014 08:55AM

I need assistance navigating character sets and collations.

I want to support pretty much every major language in all of my tables. What should my database’s charset and collation be?

Example languages I need to support: english, chinese, japanese, russian, korean, german, french, dutch, spanish, swahili, and many more.

I’ve read the docs but I do not know which char set and collation I should choose.

I have also read that there may be a problem with some collations because something like value may be equivalent to valúe. This issue is also referenced in the official docs.

If I want to support the languages mentioned above, and also choose a collation that allows u to be equivalent to ú (just an example, I don’t know if they would really be equivalent; I do not have great knowledge of collations), what charset and collation should I choose

And if I wanted to support the languages above but NOT allow u to be equivalent to ú, which charset and collation should I choose?

(I've tried to post this multiple times but something went wrong in all previous attempts. If this post appears then my other post with the same content can be deleted.)

Options: ReplyQuote


Subject Written By Posted
Charset and Collation Question Dean Richert 11/15/2014 08:55AM
Re: Charset and Collation Question Peter Brawley 11/15/2014 12:33PM
Re: Charset and Collation Question Rick James 11/15/2014 01:23PM
Re: Charset and Collation Question Dean Richert 11/16/2014 05:58AM
Re: Charset and Collation Question Rick James 11/16/2014 02:29PM
Re: Charset and Collation Question Dean Richert 11/25/2014 03:54PM
Re: Charset and Collation Question Rick James 11/25/2014 07:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.