Search Results
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...A comparison between a nonbinary string and binary string is treated as a comparison of binary ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...Example: "U+0000 NULL" does not have a weight and is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
Connection Character Set and Collation System Variables Impermissible Client Character Sets Client Program Connection Character Set Configuration SQL Statements for Connection Character Set Configuration Connection Character Set Error Handling ... A ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/create-table-select.html
The same is true for other CREATE TABLE options such as CHARSET. SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic-format tables have these characteristics: All ...Dynamic format is a little more complex than static format because each row has a header that indicates how long it ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
Note that ENUM columns can be assigned a character set and collation. Make sure that the column is sorted lexically rather than by index number by coding ORDER BY CAST(col AS CHAR) or ORDER BY CONCAT(col). An ENUM is a string object with a value ...