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-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
CHARSET(str) Returns the character set of the string argument, or NULL if the argument is NULL. mysql> SELECT CHARSET('abc'); -> 'utf8mb3' mysql> SELECT CHARSET(CONVERT('abc' USING latin1)); -> 'latin1' mysql> SELECT CHARSET(USER()); -> 'utf8mb3' ...
https://dev.mysql.com/doc/refman/8.0/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. You can check the variable value as follows, ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Converted to a number, it produces 0: mysql> SELECT CHARSET(X''), LENGTH(X''); +--------------+-------------+ | CHARSET(X'') | LENGTH(X'') | +--------------+-------------+ | binary | 0 | +--------------+-------------+ mysql> SELECT X''+0; +-------+ ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ... To ...
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).