Search Results
https://dev.mysql.com/doc/refman/8.4/en/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
Note If you use ALTER DATABASE to change the database default character set or collation, existing stored routines in the database that use those defaults must be dropped and recreated so that they use the new defaults. For applications that store ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
For example, tables named city, CITY, and City can all exist simultaneously. String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
https://dev.mysql.com/doc/refman/8.4/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set, which is the official character set of the People's Republic of China (PRC). Characteristics of ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html
For guidance in converting existing applications which use utfmb3, see Section 12.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”. utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8mb3.html
For guidance in converting existing applications which use utfmb3, see Section 12.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”. The utf8mb3 character set has these characteristics: Supports BMP characters only (no support ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. To ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
Group Replication members can also be configured to use the clone plugin as an option for distributed recovery, in which case joining members automatically choose the most efficient way to retrieve group data from existing group members. In addition ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory before cloning data from the donor. The clone plugin permits cloning data locally or from a ...