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/char.html
They also differ in maximum length and in whether trailing spaces are retained. When CHAR values are retrieved, trailing spaces are removed unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. For VARCHAR columns, trailing spaces in excess of the ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and Sorting Character Set Conversion Lettercase Conversion Trailing Space Handling in Comparisons Trailing Space ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str) Returns the string str with all remstr prefixes or suffixes removed. If none of the specifiers BOTH, LEADING, or TRAILING is given, BOTH is assumed. mysql> SELECT TRIM(' ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
--preserve-trailing-spaces, -P Command-Line Format --preserve-trailing-spaces Cause trailing spaces to be preserved when promoting a fixed-width character data type to its variable-width equivalent—that is, when promoting a CHAR column value to ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
For comparison of nonbinary strings, NO PAD collations treat spaces at the end of strings like any other character (see Trailing Space Handling in Comparisons). This section describes the collations available for Unicode character sets and their ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
MySQL also recognizes the ODBC syntax corresponding to the standard SQL syntax: { d 'str' } { t 'str' } { ts 'str' } MySQL uses the type keywords and the ODBC constructions to produce DATE, TIME, and DATETIME values, respectively, including a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Internally, for variable-length character sets such as utf8mb3 and utf8mb4, InnoDB attempts to store CHAR(N) in N bytes by trimming trailing spaces. If the byte length of a CHAR(N) column value exceeds N bytes, trailing spaces are trimmed to a ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
A trailing zone ID is not permitted, as in fe80::3%1 or fe80::3%eth0. A trailing network mask is not permitted, as in 2001:45f:3:ba::/64 or 198.51.100.0/24. The function return value and type are the same as the return value and type of its ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Values are right-padded with 0x00 for inserts, and no trailing bytes are removed for retrievals. For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting values ... The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
Specifying a trailing plus or minus sign causes InnoDB to report a syntax error. The boolean full-text search capability supports the following operators: + A leading or trailing plus sign indicates that this word must be present in each row that is ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...