Mysql what should collation be

Are two values the same or is one larger than the other? For numbers this is in general well defined floating point comparisons and release numbers are examples where it is less clear , for example 10 is greater than 5. However, for strings it is not that simple. Different languages have different rules for the order of the characters, and there are the questions whether an accented character should be considered the same as the base character and whether upper and lower case should be considered the same.

The rules that define the order of the characters and whether to take accents and capitalization into account is called collations. There are many collations for the same character set.

In MySQL 8. For example, to see the 73 collations available for utf8mb The most interesting in this discussion is the name. As you can see there is a pattern to the names, and it is possible to identify up to four parts in the name. As part of the work to make utf8mb4 the default character set in MySQL 8. Some of the changes include:. For these reasons it is recommended to use utf8mb4 with one of the new UCA 9. The default collation for utf8mb4 in MySQL 8.

This is a good collation for the general use cases, but feel free to use one of the more specific collations if that works better for your application. Character sets and collations are big topics. Like Article. Fetching char-set using LIKE statement. Recommended Articles. Article Contributed By :. Easy Normal Medium Hard Expert.

Writing code in comment? Please use ide. Load Comments. Every database has a database character set and a database collation. MySQL chooses the database character set and database collation in the following manner:. The server sets these variables whenever the default database changes. To see the default character set and collation for a given database, use these statements:. The database character set and collation affect these aspects of server operation:.

Character Sets and Collations in General. Specifying Character Sets and Collations. Collation Naming Conventions. Column Character Set Conversion. Character Set and Collation Compatibility. Collation Coercibility in Expressions. Examples of the Effect of Collation. The utf8 Character Set Alias for utf8mb3.

Supported Character Sets and Collations. Central European Character Sets. Restrictions on Character Sets. Setting the Error Message Language. Adding a Collation to a Character Set.

Collation Implementation Types.