Which collation should I use when my entire application goes for UTF-8?

views:

answers:

+2 Q:

Which collation should I use when my entire application goes for UTF-8?

I'm using MySQL, latest version. By default I get *latin1_swedish_ci* which doesn't sound really correct.

+2 A:

You can change the default collation from the MySQL database configuration files.

Also see this link http://streetsmartingit.blogspot.com/2008/04/how-to-changeconvert-your-mysql.html for instructions on doing it with an existing database.

PfhorSlayer 2010-01-01 18:47:19

also at an 15$ hoster?

openfrog 2010-01-01 21:07:18

+3 A:

You should use utf8_general_ci

Here is a full list of the character sets and their descriptions from the MySQL reference site.

Doug Neiner 2010-01-01 18:48:48

utf8_general_ci is the way to go. You will want to convert all your tables into utf8, this is the best collation to use in general.If you have any columns which store non human-readable stuff which needs to be case sensitive (e.g. URLs), then make them utf8_binary

MarkR 2010-01-01 21:52:49