https://dev.mysql.com/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/charset-applications.html
To select a character set and collation if you configure and build MySQL from source, use the DEFAULT_CHARSET and DEFAULT_COLLATION CMake options: cmake . -DDEFAULT_CHARSET=latin1 \ -DDEFAULT_COLLATION=latin1_swedish_ci The resulting server uses ...
https://dev.mysql.com/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/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/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/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/mysql-commands.html
For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are disabled except charset and delimiter in noninteractive mode (for input piped to mysql or loaded using the source command). charset ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/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/charset-collations.html
The following sections discuss various aspects of character set collations.
https://dev.mysql.com/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 ...
