Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and collation: CHARACTER SET specifies the character set. If desired, a collation for the character ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
This differs from comparisons performed with the = operator, for which the significance of trailing spaces in nonbinary strings (CHAR, VARCHAR, and TEXT values) depends on the pad attribute of the collation used for the comparison. mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
mysql> SELECT CHARSET('abc'); -> 'utf8mb3' mysql> SELECT CHARSET(CONVERT('abc' USING latin1)); -> 'latin1' mysql> SELECT CHARSET(USER()); -> 'utf8mb3' COERCIBILITY(str) Returns the collation coercibility value of the string argument. mysql> SELECT ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. For any alter_option omitted from the statement, the database retains its current option value, with the exception that changing the character set may change the collation and vice ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
It is also possible to store CJK characters in Unicode character sets, although the available collations may not sort characters quite as you expect: The utf8 and ucs2 character sets support the characters from Unicode Basic Multilingual Plane (BMP). The collation used for a Unicode character set determines the ability to sort (that is, distinguish) characters in the set: Collations based on Unicode Collation Algorithm (UCA) 4.0.0 distinguish only BMP ...
https://dev.mysql.com/doc/refman/8.4/en/charset-we-sets.html
ascii (US ASCII) collations: ascii_bin ascii_general_ci (default) cp850 (DOS West European) collations: cp850_bin cp850_general_ci (default) dec8 (DEC Western European) collations: dec8_bin dec8_swedish_ci (default) The dec character set is ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-30.html
Character Set Support Packaging Notes Functionality Added or Changed Bugs Fixed Character Set Support The renaming of the utf8 character set to utf8mb3 in MySQL 8.0.30—together with new utf8mb4 collations—generated errors related to collation ...For applications using X DevAPI or X DevAPI for C (breaking changes): The CharacterSet::utf8 enumeration constant was renamed to CharacterSet::utf8mb3, but the constant value (21) did not ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
But this approach produces a new issue when trying to use the index: CAST() returns a string with the collation utf8mb4_0900_ai_ci (the server default collation). As a result, there is a collation mismatch between the indexed expression in the ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-rules.html
MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and ...This ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The COLLATE attribute can be used if preceded by a CHARACTER SET specification. For character data types, if CHARACTER SET is included in the declaration, the specified character set and its default collation is used. If the COLLATE attribute is ...