PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...