PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
To use a WHERE clause with SHOW CHARACTER SET, you would refer to those column names. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
All international alphabetic characters outside the A-Z range are treated as vowels. ASCII(str) Returns the numeric value of the leftmost character of the string str. [USING charset_name]) CHAR() interprets each argument N as an integer and returns ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
Both functions support an input string that is encoded in any character set: mask_inner() masks the interior of its string argument, leaving the ends unmasked. For more information about generation functions, see Generating Random Data with Specific ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
Any character is legal in database or table identifiers except ASCII NUL (X'00'). MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: Basic Latin letters ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
A collation is a set of rules that defines how to compare and sort character strings. Every character set has at least one collation, and most have two or more collations. Characters with equal weights compare as equal, and characters with unequal ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from ...For ...
https://dev.mysql.com/doc/refman/8.0/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...Note UTF8 is ...