PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-syntax.html
There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. The intended use is from within the mysql client, which reports query execution ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. 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.0/en/charset-asian-sets.html
The Asian character sets that we support include Chinese, Japanese, Korean, and Thai. For example, the Chinese sets must allow for thousands of different characters. See Section 12.10.7.1, “The cp932 Character Set”, for additional information ...
https://dev.mysql.com/doc/refman/8.0/en/charset-baltic-sets.html
The Baltic character sets cover Estonian, Latvian, and Lithuanian languages. cp1257 (Windows Baltic) collations: cp1257_bin cp1257_general_ci (default) cp1257_lithuanian_ci latin7 (ISO 8859-13 Baltic) collations: latin7_bin latin7_estonian_cs ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/charset-ce-sets.html
MySQL provides some support for character sets used in the Czech Republic, Slovakia, Hungary, Romania, Slovenia, Croatia, Poland, and Serbia (Latin).
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.