Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-charsets.html
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 wrong collation, it can be helpful to perform some comparisons with ...There is one subsection for each group of related character ...
https://dev.mysql.com/doc/refman/8.4/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...To maximize ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-collation-character-set-applicability-table.html
The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is associated. Notes The COLLATION_CHARACTER_SET_APPLICABILITY ...
https://dev.mysql.com/doc/refman/8.4/en/charset-syntax.html
There are default settings for character sets and collations at four levels: server, database, table, and column. For example, to use the latin1 Unicode character set, issue this statement after connecting to the server: SET NAMES 'latin1'; For ...
https://dev.mysql.com/doc/refman/8.4/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...It tells the parser, “the string that follows uses character set charset_name.” An introducer does not change the string to the introducer character set like CONVERT() would ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3721; Symbol: ER_INVALID_DEFAULT_UTF8MB4_COLLATION; SQLSTATE: HY000 Message: Invalid default collation %s: utf8mb4_0900_ai_ci or utf8mb4_general_ci expected Error number: 3722; Symbol: ER_UNABLE_TO_COLLECT_LOG_STATUS; SQLSTATE: HY000 ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
For information about the differences between the binary collation of the binary character set and the _bin collations of nonbinary character sets, see Section 12.8.5, “The binary Collation Compared to _bin Collations”. For a character column ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For example, if e and é have the same sort value in a given collation, they compare as equal. The default character set and collation are ...
https://dev.mysql.com/doc/refman/8.4/en/adding-character-set.html
The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not need multibyte character support, it is simple. <collation ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
See also Section 12.4, “Connection Character Sets and Collations”.) The global value of the variable is used to set the session value in cases when the client-requested value is unknown or not available, or the server is configured to ignore ...