https://dev.mysql.com/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. One context in which you will see binary is for compression functions, which return binary strings as a general rule: string: mysql> SELECT ...For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons will be ...
https://dev.mysql.com/char.html
The pad attribute determines how trailing spaces are treated for comparison of nonbinary strings (CHAR, VARCHAR, and TEXT values). “Comparison” in this context does not include the LIKE pattern-matching operator, for which trailing spaces are ...
https://dev.mysql.com/charset-conversion.html
If the column has a nonbinary data type (CHAR, VARCHAR, TEXT), its contents should be encoded in the column character set, not some other character set. To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/check-table.html
Column Value Table The table name Op Always check Msg_type status, error, info, note, or warning Msg_text An informational message The statement might produce many rows of information for each checked table. The last row has a Msg_type value of ...
https://dev.mysql.com/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This is more reliable than using MD5 checksums, but requires more work. GnuPG is an Open Source alternative to the well-known Pretty Good ...
https://dev.mysql.com/comp-err.html
It compiles the errmsg.sys file from the text file located at sql/share/errmsg-utf8.txt in MySQL source distributions. comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes.
https://dev.mysql.com/condition-pushdown-optimization.html
Columns used in comparisons cannot be of any of the BLOB or TEXT types. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage ...
https://dev.mysql.com/crashing.html
If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all VARCHAR to CHAR with ALTER TABLE. Each MySQL version is tested on many platforms before it ...
https://dev.mysql.com/create-event.html
The comment text, being a string literal, must be surrounded by quotation marks. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] ...
