Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/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/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/charset-binary-collations.html
The pad attribute determines how trailing spaces are treated for comparison of nonbinary strings (CHAR, VARCHAR, and TEXT values): For PAD SPACE collations, trailing spaces are insignificant in comparisons; strings are compared without regard to any ... This section describes how the binary collation for binary strings compares to _bin collations for nonbinary ...
https://dev.mysql.com/mysql-cluster-programs-ndb-restore.html
--preserve-trailing-spaces, -P Property Value 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 ...
https://dev.mysql.com/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/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/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 ...
https://dev.mysql.com/date-and-time-literals.html
DATE 'str' TIME 'str' TIMESTAMP 'str' MySQL recognizes those constructions and also the corresponding ODBC syntax: { d 'str' } { t 'str' } { ts 'str' } MySQL uses the type keyword and these constructions produce DATE, TIME, and DATETIME values, ...
https://dev.mysql.com/binary-varbinary.html
Values are right-padded with 0x00 on insert, and no trailing bytes are removed on select. For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the ...
https://dev.mysql.com/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 ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-trailing-p-1.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
