PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/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 ...For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character ...
https://dev.mysql.com/doc/refman/8.0/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 | ...What ...
https://dev.mysql.com/doc/refman/8.0/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' ...Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | +--------------------------------+------------------------------+ | XXX-XXX-XXX | XXXXXXXXX | ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
NCHAR[(N)] Like CHAR, but produces a string with the national character set. A common use for BINARY is to force a character string comparison to be done byte by byte using numeric byte values rather than character by character. For information ...
https://dev.mysql.com/doc/refman/8.0/en/charset-asian-sets.html
See Section 12.10.7.2, “The gb18030 Character Set”, for additional information about character set support for the Chinese National Standard GB 18030. The Asian character sets that we support include Chinese, Japanese, Korean, and Thai. For ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; For information about these forms of string syntax, see Section 12.3.7, “The National Character Set”, and Section 12.3.8, “Character Set ... A ...Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
Connection Character Set and Collation System Variables Impermissible Client Character Sets Client Program Connection Character Set Configuration SQL Statements for Connection Character Set Configuration Connection Character Set Error Handling ... A ...