https://dev.mysql.com/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); .
https://dev.mysql.com/charset-cyrillic-sets.html
The Cyrillic character sets and collations are for use with Belarusian, Bulgarian, Russian, Ukrainian, and Serbian (Cyrillic) languages. cp1251 (Windows Cyrillic) collations: cp1251_bin cp1251_bulgarian_ci cp1251_general_ci (default) ...
https://dev.mysql.com/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 10.11, “Setting the Error Message Language”. For ...
https://dev.mysql.com/charset-examples.html
The following examples show how MySQL determines default character set and collation values. Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE ...
https://dev.mysql.com/charset-general.html
A character set is a set of symbols and encodings. A collation is a set of rules for comparing characters in a character set. Let's make the distinction clear with an example of an imaginary character set. Suppose that we have an alphabet with four ...
https://dev.mysql.com/charset-literal.html
A character string 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]'string' [COLLATE collation_name] The _charset_name ... Every ...
https://dev.mysql.com/charset-metadata.html
Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is metadata. Thus column names, database names, user names, version names, and most of the string results from SHOW ...
https://dev.mysql.com/charset-national.html
Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character set. For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As ...
https://dev.mysql.com/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only characters in the Unicode range U+0000 to U+007F.
