PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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-functions.html
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 a string consisting of the characters given by the code values of those integers. For ...
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
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 about the differences between the binary collation of the binary character set ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
What problems should I be aware of when working with the Big5 Chinese character set? A.11.4. Of what issues should I be aware when working with Korean character sets in MySQL? A.11.8. Why does my GUI front end or browser display CJK characters ...
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/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character units. Column definitions ...
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-import.html
--fields-enclosed-by=char Command-Line Format --fields-enclosed-by=char Type String Default Value [none] This works in the same way as the FIELDS ENCLOSED BY option does for the LOAD DATA statement, specifying a character to be interpreted as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Tables that use the REDUNDANT row format store the first 768 bytes of variable-length column values (VARCHAR, VARBINARY, and BLOB and TEXT types) in the index record within the B-tree node, with the remainder stored on overflow pages. For example, a ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...