PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
The default character set and collation are utf8mb4 and utf8mb4_0900_ai_ci, so nonbinary string comparisons are case-insensitive by default. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands.
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
utf8mb4_general_ci is an example: 'a', 'A', 'À', and 'á' each have different character codes but all have a weight of 0x0041 and compare as equal. mysql> SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'; Query OK, 0 rows affected (0.05 sec) mysql> ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
The utf8mb4, utf16, utf16le, and utf32 character sets support BMP characters, as well as supplementary characters that lie outside the BMP. For example, the utf8mb4 default collation is utf8mb4_general_ci, which distinguishes only BMP characters.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
utf8mb3 and utf8mb4 character sets can require up to three and four bytes per character, respectively. For a breakdown of the storage used for different categories of utf8mb3 or utf8mb4 characters, see Section 12.9, “Unicode Support”. For ...
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
The example adds a collation named utf8mb4_phone_ci to the utf8mb4 character set. Within the <collation> element, provide a <rules> element containing the ordering rules: <charset name="utf8mb4"> ... <collation name="utf8mb4_phone_ci" id="1029"> ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.