https://dev.mysql.com/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...
https://dev.mysql.com/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/charset-connection.html
C applications can use character set autodetection based on the OS setting by invoking mysql_options() as follows before connecting to the server: mysql_options(mysql, MYSQL_SET_CHARSET_NAME, MYSQL_AUTODETECT_CHARSET_NAME); Each client supports a ...
https://dev.mysql.com/adding-character-set.html
A partial listing for the latin1 <charset> element follows: <charset name="latin1"> <family>Western</family> <description>cp1252 West European</description> ... </charset> The <charset> element must list all the collations for the character set. For ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/mysqldump.html
--no-set-names, -N Turns off the --set-charset setting, the same as specifying --skip-set-charset. This option enables the --skip-add-drop-table, --skip-add-locks, --skip-comments, --skip-disable-keys, and --skip-set-charset options. --opt This ...
https://dev.mysql.com/charset-configuration.html
The examples given here show what the setting might look like for Unix or Windows, respectively: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets [client] character-sets-dir="C:/Program Files/MySQL/MySQL Server 8.0/share/charsets" ... The MySQL server has a compiled-in default character set and ...
https://dev.mysql.com/charset-mysql.html
mysql> SHOW CHARACTER SET; +----------+---------------------------------+---------------------+--------+ | Charset | Description | Default collation | Maxlen | +----------+---------------------------------+---------------------+--------+ | big5 | ...
https://dev.mysql.com/information-functions.html
mysql> SELECT CHARSET('abc'); -> 'utf8' mysql> SELECT CHARSET(CONVERT('abc' USING latin1)); -> 'latin1' mysql> SELECT CHARSET(USER()); -> 'utf8' COERCIBILITY(str) Returns the collation coercibility value of the string argument. It may be used to ...
https://dev.mysql.com/charset-binary-set.html
The binary character set is the chararcter set of binary strings, which are sequences of bytes. The effect is that lettercase and accent differences are significant in comparisons. To convert a string expression to a binary string, any of these ...
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 ...
