CODEWITHSUNDEEP
mysql
Ben Sinclair
Ben Sinclair

Reputation: 3986

Changing MySQL database from utf8_general_ci to utf8_bin - Good idea?

I recently learnt that if you do not want MySQL to read å as an a or ö as an o, you need to use the uft8_bin collation.

My site is multi-tenant so not everyone needs the utf8_bin collation. Some of my customers are in Norway and Finland and they require these "non-english" characters to be ordered correctly.

But would it be a good idea to set the tables to utf8_bin anyway?

Or is there a better way such as setting the collation to utf8_bin only if they are a non-english country?

Will this affect anyone from an English country or does utf8_bin act the same as utf8_general_ci but has the added bonus of ordering å, ö, etc correctly?

Or is there a better option than utf8_bin?

Upvotes: 4

Views: 1167

Answers (1)

Ry-
Ry-

Reputation: 224867

utf8_general_ci orders å and ö correctly. The difference between the utf8_*_ci and the utf8_bin collations is that the former is Case-Insensitive.

Upvotes: 3

Related Questions