Search Results
https://dev.mysql.com/doc/refman/8.4/en/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); Both the UNICODE attribute and the ucs2 character set are deprecated; you should expect them to be ...
https://dev.mysql.com/doc/refman/8.4/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set, which is the official character set of the People's Republic of China (PRC). Characteristics of ...
https://dev.mysql.com/doc/refman/8.4/en/charset-introducer.html
To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. A character string literal, hexadecimal literal, or bit-value literal may have an optional character set ...
https://dev.mysql.com/doc/refman/8.4/en/charset-national.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; MySQL 8.4 interprets the national character set as utf8mb3, which is now deprecated. Standard SQL defines NCHAR or NATIONAL CHAR as a way to ...
https://dev.mysql.com/doc/refman/8.4/en/charset-repertoire.html
Consider these statements: SET NAMES utf8mb4; SELECT 'abc'; SELECT _utf8mb4'def'; Although the character set is utf8mb4 in each of the preceding cases, the strings do not actually contain any characters outside the ASCII range, so their repertoire ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-server.html
The server character set and collation are used as default values if the database character set and collation are not specified in CREATE DATABASE statements. MySQL Server has a server character set and a server collation. By default, these are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-syntax.html
For example, to use the latin1 Unicode character set, issue this statement after connecting to the server: SET NAMES 'latin1'; For more information about character set-related issues in client/server communication, see Section 12.4, “Connection ...
https://dev.mysql.com/doc/refman/8.4/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.4, SHOW statements and columns of INFORMATION_SCHEMA tables display utf8mb3 instead. For more information, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/charset-we-sets.html
Although it is frequently said that it is based on the Swedish/Finnish collation rules, there are Swedes and Finns who disagree with this statement. Western European character sets cover most West European languages, such as French, Spanish, ...
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 ...