PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...
https://dev.mysql.com/doc/refman/8.0/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, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collations.html
The following sections discuss various aspects of character set collations.
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
If CHARACTER SET charset_name is specified without COLLATE, character set charset_name and its default collation are used. Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character ...