Character Set Repertoire | utf8mb4_sinhala_ci | utf8mb4 | 243 | | Yes | 8 | PAD SPACE | | utf8mb4_sk_0900_ai_ci | utf8mb4 | 269 | | Yes | 0 | NO PAD | | utf8mb4_sk_0900_as_cs | utf8mb4 | 292 | | Yes | 0 | NO PAD | | utf8mb4_slovak_ci | utf8mb4 | 237 | | Yes | 8 | PAD SPACE | | utf8mb4_slovenian_ci | utf8mb4 | 228 | | Yes | 8 | PAD SPACE | | utf8mb4_sl_0900_ai_ci | utf8mb4 | 260 | | Yes | 0 | NO PAD | | utf8mb4_sl_0900_as_cs | utf8mb4 | 283 | | Yes | 0 | NO PAD | | utf8mb4_spanish2_ci | utf8mb4 | 238 | | Yes | 8 | PAD SPACE | | utf8mb4_spanish_ci | utf8mb4 | 231 | | Yes | 8 | PAD SPACE | | utf8mb4_sv_0900_ai_ci | utf8mb4 | 264 | | Yes | 0 | NO PAD | | utf8mb4_sv_0900_as_cs | utf8mb4 | 287 | | Yes | 0 | NO PAD | | utf8mb4_swedish_ci | utf8mb4 | 232 | | Yes | 8 | PAD SPACE | | utf8mb4_tr_0900_ai_ci | utf8mb4 | 265 | | Yes | 0 | NO PAD | | utf8mb4_tr_0900_as_cs | utf8mb4 | 288 | | Yes | 0 | NO PAD | | utf8mb4_turkish_ci | utf8mb4 | 233 | | Yes | 8 | PAD SPACE | | utf8mb4_unicode_520_ci | utf8mb4 | 246 | | Yes | 8 | PAD SPACE | | utf8mb4_unicode_ci | utf8mb4 | 224 | | Yes | 8 | PAD SPACE | | utf8mb4_vietnamese_ci | utf8mb4 | 247 | | Yes | 8 | PAD SPACE | | utf8mb4_vi_0900_ai_ci | utf8mb4 | 277 | | Yes | 0 | NO PAD | | utf8mb4_vi_0900_as_cs | utf8mb4 | 300 | | Yes | 0 | NO PAD | | utf8mb4_zh_0900_as_cs | utf8mb4 | 308 | | Yes | 0 | NO PAD | +----------------------------+---------+-----+---------+----------+---------+---------------+ For more information about those collations, see Section 10.10.1, “Unicode Character Sets” . Collations have these general characteristics: •Two different character sets cannot have the same collation. •Each character set has a  default collation . For example, the default collations for  utf8mb4  and  latin1 are  utf8mb4_0900_ai_ci  and  latin1_swedish_ci , respectively. The  INFORMATION_SCHEMA CHARACTER_SETS  table and the  SHOW CHARACTER SET  statement indicate the default collation for each character set. The  INFORMATION_SCHEMA COLLATIONS  table and the  SHOW COLLATION statement have a column that indicates for each collation whether it is the default for its character set ( Yes  if so, empty if not). •Collation names start with the name of the character set with which they are associated, generally followed by one or more suffixes indicating other collation characteristics. For additional information about naming conventions, see Section 10.3.1, “Collation Naming Conventions” . When a character set has multiple collations, it might not be clear which collation is most suitable for a given application. To avoid choosing an inappropriate collation, perform some comparisons with representative data values to make sure that a given collation sorts values the way you expect. The  repertoire  of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: • ASCII : The expression can contain only ASCII characters; that is, characters in the Unicode range  U +0000  to  U+007F . • UNICODE : The expression can contain characters in the Unicode range  U+0000  to  U+10FFFF . This includes characters in the Basic Multilingual Plane (BMP) range ( U+0000  to  U+FFFF ) and supplementary characters outside the BMP range ( U+10000  to  U+10FFFF ). The  ASCII  range is a subset of  UNICODE  range, so a string with  ASCII  repertoire can be converted safely without loss of information to the character set of any string with  UNICODE  repertoire. It can also be converted safely to any character set that is a superset of the  ascii  character set. (All MySQL character 1929 10.2.1 Character Set Repertoire