Search Results
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-unicode-uca.html
This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml file. Instead, you begin with an existing “base” collation and ...It uses a subset of the Locale Data Markup Language (LDML) specification, which is available at ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/8.4/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. The preceding behavior occurs because the utf8mb3_general_ci collation is not used for INFORMATION_SCHEMA queries when searching for ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-choosing-id.html
To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-effect.html
The first column shows the result of the SELECT using the Swedish/Finnish collating rule, which says that U-umlaut sorts with Y. latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-collation-category.html
Lists the Collation configuration metrics and provides a brief description of each. Table 7.6 Collation Configuration Metrics NameDescriptionConnection The collation of the connection character set.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-compatibility.html
Each character set has one or more collations, but each collation is associated with one and only one character set. Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collate-precedence.html
The COLLATE clause has high precedence (higher than ||), so the following two expressions are equivalent: x || y COLLATE z x || (y COLLATE z) .
https://dev.mysql.com/doc/refman/8.4/en/string-collating.html
For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> elements. If the sorting rules for your language are too complex to be handled with simple arrays, ...The existing character sets provide the best documentation and examples to show how these functions are ...