CODEWITHSUNDEEP
mysqldatabasemultilingualcollation
inf1ux
inf1ux

Reputation: 283

What MySQL case-sensitive collation to use for a multilingual website?

The question says it all:

I have a project that needs to be multilingual and need case-sensitivity for the collation.

The database isn't MS-SQL!

Upvotes: 0

Views: 544

Answers (1)

Yuriy Nakonechnyy
Yuriy Nakonechnyy

Reputation: 3842

I switched from utf8_bin to utf8_unicode_ci which provides way better ordering of Cyrillic characters than ut8_general_ci and definitely better than utf8_bin (ordering of Cyrillic characters in utf8_bin is very wrong).

As per following Q&A: What's the difference between utf8_general_ci and utf8_unicode_ci the only drawback of utf8_unicode_ci is performance, but if one doesn't work with millions of rows, I think he/she can ignore performance penalties because accuracy should be way better.

Upvotes: 1

Related Questions