MySQL collation for all languages

mysql collation
Pedro Luz picture Pedro Luz · Sep 20, 2009 · Viewed 10.3k times · Source

I'm currently developing a website that is going to show stuff for almost any language in the world. And I'm having problems choosing the best collation to define in the MySQL.

Which one is the best to support all characters? Or the most accurate?

Or is just best to convert all characters to unicode?

Answer

stone picture stone · Sep 20, 2009

I generally use 8-bit UCS/Unicode transformation format which works perfect for any (well most) languages 

utf8_general_ci

http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html

Related questions

How do I see what character set a MySQL database / table / column is?

What is the (default) charset for: MySQL database MySQL table MySQL column

Read More
What is the best collation to use for MySQL with PHP?

I'm wondering if there is a "best" choice for collation in MySQL for a general website where you aren't 100% sure of what will be entered? I understand that all the encodings should be the same, such as MySQL, Apache, the …

Read More
What's the difference between utf8_general_ci and utf8_unicode_ci?

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?

Read More