Search Results
https://dev.mysql.com/doc/refman/8.4/en/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 ...Please consider using CHAR(x) CHARACTER SET UTF8MB4 in order to be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The query lists the nations in ascending alphabetical order and, for each nation, the year and profit in descending order by year (most recent first). mysql-sql> USE tpch; mysql-sql> ALTER TABLE customer SECONDARY_UNLOAD; mysql-sql> ALTER TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
The EXPLAIN plan output shows that there is no common predicate between the first two table entries (NATION and SUPPLIER). mysql> EXPLAIN SELECT o_orderkey, c_custkey, l_shipdate, s_nationkey, s_suppkey, l_comment FROM lineitem, supplier, nation, ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. NATIONAL CHAR (or its equivalent short form, NCHAR) is the standard SQL way ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
mysql> SELECT ucs2,HEX(ucs2),gb2312,HEX(gb2312) FROM ch; +-------+--------------+--------+-------------+ | ucs2 | HEX(ucs2) | gb2312 | HEX(gb2312) | +-------+--------------+--------+-------------+ | A汌B | 00416C4C0042 | A?B | 413F42 | ... This set ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns the number with all but the first two letters (denoting the country) replaced by '*' characters. Each country can have a different national routing or account ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.4/en/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the server. The client sends SQL statements, such as queries, over the session connection. The server sends ...
https://dev.mysql.com/doc/refman/8.4/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
The reason is that utf8mb4_unicode_ci supports mappings such as expansions; that is, when one character compares as equal to combinations of other characters. (See Section 14.8, “String Functions and Operators”.) If a collation uses a weight ...