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/charset-unicode-utf8mb4.html
The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
| utf8mb3 | UTF-8 Unicode | utf8mb3_general_ci | 3 | | utf8mb4 | UTF-8 Unicode | utf8mb4_0900_ai_ci | 4 | ... For example, the default collations for utf8mb4 and latin1 are utf8mb4_0900_ai_ci and latin1_swedish_ci, respectively. MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
Return value: The masked Canada SIN as a string encoded in the utf8mb4 character set, an error if the argument is not the correct length, or NULL if str is in incorrect format or contains a multibyte character. Return value: The masked International ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...One ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
For example, this statement converts the string 'abc' in the default character set to the corresponding string in the utf8mb4 character set: SELECT CONVERT('abc' USING utf8mb4); CONVERT(expr, type) syntax (without USING) takes an expression and a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per character. This character set is deprecated in MySQL 8.0, and you should use utf8mb4 instead. utf8 is expected in a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
Exception: For string literals that have an introducer such as _utf8mb4 or _latin2, the introducer determines the character set. The mysql, mysqladmin, mysqlcheck, mysqlimport, and mysqlshow client programs determine the default character set to use ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
character_set_client System Variable character_set_client Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String Default Value utf8mb4 The character set for statements that arrive from the client. character_set_connection System ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
MySQL handles strings used in JSON context using the utf8mb4 character set and utf8mb4_bin collation. Strings in other character sets are converted to utf8mb4 as necessary. (For strings in the ascii or utf8mb3 character sets, no conversion is needed ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Important change: The default character set has changed from latin1 to utf8mb4. These system variables are affected: The default value of the character_set_server and character_set_database system variables has changed from latin1 to utf8mb4. The ...