Search Results
https://dev.mysql.com/doc/refman/8.4/en/bit-functions.html
You can specify arguments to bit operations using hexadecimal literals or bit literals with the intent that they represent numbers; MySQL evaluates bit operations in numeric context when all bit arguments are hexadecimal or bit literals. In numeric ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
For nonbinary strings (CHAR, VARCHAR, and TEXT values), the string collation pad attribute determines treatment in comparisons of trailing spaces at the end of strings. The CHAR and VARCHAR types are similar, but differ in the way they are stored ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
The examples shown here assume use of the latin1 character set and latin1_swedish_ci collation in particular contexts as an alternative to the defaults of utf8mb4 and utf8mb4_0900_ai_ci. For example, if you intend to send statements using UTF-8 text ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
Nonbinary strings (as stored using the CHAR, VARCHAR, and TEXT data types) have a character set and collation other than binary. For nonbinary strings (CHAR, VARCHAR, and TEXT values), the string collation pad attribute determines treatment in ...
https://dev.mysql.com/doc/refman/8.4/en/charset-column.html
Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
Consequently, BLOB and TEXT columns cannot be included in a foreign key because indexes on those columns must always include a prefix length. For NDB tables, ON DELETE CASCADE is not supported where the child table contains one or more columns of ...
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. When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. The CSV storage ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in ... MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
Why do some LIKE and FULLTEXT searches with CJK characters fail? A.11.12. Sometimes adding or changing a <meta> tag suffices to correct the problem: for example, to insure that the user agent interprets page content as UTF-8, include <meta ... This ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change buffer? A.16.5. How do I determine the current size of the change buffer? A.16.6. Where can I find additional ...