Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-set.html
For information about the differences between the binary collation of the binary character set and the _bin collations of nonbinary character sets, see Section 12.8.5, “The binary Collation Compared to _bin Collations”. The binary character set ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name | ENCRYPTION [=] {'Y' | 'N'} } CREATE DATABASE creates a database with the given name. For information about character set and collation names, see Chapter 12, ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
MySQL handles strings used in JSON context using the utf8mb4 character set and utf8mb4_bin collation. Strings produced by converting JSON values have a character set of utf8mb4 and a collation of utf8mb4_bin: mysql> SELECT CHARSET(@j), ...The JSON ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
unsigned int charsetnr An ID number that indicates the character set/collation pair for the field. charsetnr values are the same as those displayed in the Id column of the SHOW COLLATION statement or the ID column of the INFORMATION_SCHEMA ... This ...
https://dev.mysql.com/doc/refman/8.4/en/charset-gb18030.html
Searches for ligatures also match uppercase ligatures when using the gb18030_unicode_520_ci collation. Chinese characters are sorted according to the Pinyin collation defined in the Unicode Common Locale Data Repository (CLDR 24). Use this collation ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
In addition, changing the character set or collation for a given database, table, or column after such a table is created may cause changes in how rows are distributed. For example, when using a case-sensitive collation, 'and' sorts before ... Range ...
https://dev.mysql.com/doc/refman/8.4/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...The default ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...To ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...To ...