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-server.html
MySQL Server has a server character set and a server collation. Initially, the server character set and collation depend on the options that you use when you start mysqld. If you specify only a character set (for example, utf8mb4) but not a ...By ...
https://dev.mysql.com/doc/refman/8.0/en/collation-diagnostics.html
For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered warning: Unknown LDML tag: 'charsets/charset/collation/rules/aaa' If collation initialization is not possible, the server reports an ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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/refman/8.0/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.0/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.0/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 ...