CODEWITHSUNDEEP
mysqlcollationcyrillic
Olya
Olya

Reputation: 25

MySQL collation Russian and Finnish

I want to set a db column collation as Russian and Finnish. I found that there are either Russian or Finnish collations, but no simultaneous ones.

For Russian symbols ALTER TABLE Teams CHANGE Name CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL;

For Finnish symbols ALTER TABLE Teams CHANGE Name CHARACTER SET cp1251 COLLATE latin1_swedish_ci NOT NULL;

Is there any possibility to store both RU/FI symbols?

Upvotes: 2

Views: 3332

Answers (1)

Pekka
Pekka

Reputation: 449485

Use UTF-8.

It's the modern and vastly superior choice, and covers all the characters you need (and more):

The idea of UTF-8 is that various Unicode characters are encoded using byte sequences of different lengths:

Basic Latin letters, digits, and punctuation signs use one byte.

Most European and Middle East script letters fit into a 2-byte sequence: extended Latin letters (with tilde, macron, acute, grave and other accents), Cyrillic, Greek, Armenian, Hebrew, Arabic, Syriac, and others.

If you are working in a PHP context, see this question for advice on how to implement UTF-8.

Upvotes: 5

Related Questions