Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. Most Unicode character sets have a general collation (indicated by _general in the name or by the absence of a language specifier), a ...MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The MySQL 8.4 server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...For 8-bit characters, character codes map to weights in case-insensitive ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-names.html
MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation characteristics. For example, ...For ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...The ID must be unused, so choose a value different from 1025 if that ID is already taken on your ...
https://dev.mysql.com/doc/refman/8.4/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-simple-8bit.html
This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in the MySQL Index.xml file. The example adds a collation named latin1_test_ci ...These files are located in the directory named by the character_sets_dir system ...