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/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-ucs2.html
Note The ucs2 character set is deprecated in MySQL 8.0.28; expect it to be removed in a future MySQL release. In UCS-2, every character is represented by a 2-byte Unicode code with the most significant byte first. For Unicode characters and their ...For example: LATIN CAPITAL LETTER A has the code 0x0041 and it is stored as a 2-byte sequence: 0x00 ...
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. The example adds a collation named latin1_test_ci ...Choose a collation ID, as shown in Section 12.14.2, “Choosing a Collation ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html
utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this usage is now deprecated; in MySQL 8.0, SHOW statements and columns of INFORMATION_SCHEMA tables display utf8mb3 instead. For more information, see Section ...utf8mb3 remains supported for the lifetimes of the MySQL 8.0.x and following LTS release series, as well as in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml file. The following table lists the base collations of the Unicode ...It uses a subset of the Locale Data Markup Language (LDML) specification, which is available at ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and English. ascii ...For the “undefined” entries in cp1252, MySQL translates 0x81 to Unicode 0x0081, 0x8d to 0x008d, 0x8f to 0x008f, 0x90 to 0x0090, and 0x9d to ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-compatibility.html
Each character set has one or more collations, but each collation is associated with one and only one character set. Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...
https://dev.mysql.com/doc/refman/8.0/en/string-collating.html
For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> elements. The existing character sets provide the best documentation and examples to show how ...
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 ...