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/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. The length of a CHAR column is ...
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 ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...In some cases, MySQL may change a ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
All international alphabetic characters outside the A-Z range are treated as vowels. ASCII(str) Returns the numeric value of the leftmost character of the string str. [USING charset_name]) CHAR() interprets each argument N as an integer and returns ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Storage requirements for some data types depend on factors such as storage engine, storage format, and character set. mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), ... This section describes limits on the number of columns in tables and the size of individual ...
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/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/mysql-command-options.html
Batch mode results in nontabular output format and escaping of special characters. --binary-as-hex when enabled affects display of all binary strings, including those returned by functions such as CHAR() and UNHEX(). It also disables all mysql ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
The password must be 1 to 256 characters in length, and must be enclosed by single or double quotation marks. It can contain any of the ASCII characters having character codes 32, 35, 38, 40-91, 93, 95, and 97-126; in other words, it can use any ...
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 | ...