Re: Sort order for slavic characters
Posted by: Bernt Marius Johnsen
Date: July 04, 2019 04:32AM

There is no such thing as a "pan european charset". Unicode is a universal character set and what you are looking for is the proper collation for your case.
MySQL 8.0 supports the following Slavic collations based on Unicode 9.0.0:

Czech: utf8mb4_cs_0900_ai_ci and utf8mb4_cs_0900_as_cs
Slovak: utf8mb4_sk_0900_ai_ci and utf8mb4_sk_0900_as_cs
Polish: utf8mb4_pl_0900_ai_ci and utf8mb4_pl_0900_as_cs
Croatian: utf8mb4_hr_0900_ai_ci and utf8mb4_hr_0900_as_cs
Russian: utf8mb4_ru_0900_ai_ci and utf8mb4_ru_0900_as_cs
(The last one is of course for Cyrillic letters)

There are some older Slavic collations/character sets in MySQL too, but we recommend the utf8mb4 character set with the *0900* collations.

Options: ReplyQuote


Subject
Views
Written By
Posted
483
June 25, 2019 12:38PM
Re: Sort order for slavic characters
347
July 04, 2019 04:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.