Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
Changing the Character Set To change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name; The statement also ...
https://dev.mysql.com/doc/refman/8.4/en/charset-asian-sets.html
The Asian character sets that we support include Chinese, Japanese, Korean, and Thai. For example, the Chinese sets must allow for thousands of different characters. See Section 12.10.7.1, “The cp932 Character Set”, for additional information ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
TO_BASE64(str) Converts the string argument to base-64 encoded form and returns the result as a character string with the connection character set and collation. It can be used for testing and debugging of collations, especially if you are adding a ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
MySQL collations have a pad attribute of PAD SPACE, other than Unicode collations based on UCA 9.0.0 and higher, which have a pad attribute of NO PAD. To determine the pad attribute for a collation, use the INFORMATION_SCHEMA COLLATIONS table, which ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
Every binary string has a character set and collation named binary. It has a character set other than binary and a collation that is compatible with the character set. (For more information, see Section 12.8.5, “The binary Collation Compared to ...
https://dev.mysql.com/doc/refman/8.4/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
A collation for the character set can be specified with the COLLATE attribute, along with any other attributes. Example: CREATE TABLE t (c CHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin); MySQL 8.4 interprets length specifications in character ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
By default, regular expression operations use the character set and collation of the expr and pat arguments when deciding the type of a character and performing the comparison. If the arguments have different character sets or collations, ...This ...
https://dev.mysql.com/doc/internals/en/character-set.html
MySQL has a very flexible character set support as documented in Character Sets, Collations, Unicode. Fields charset_nr (2) -- number of the character set and collation This “charset” ID is actually a collation ID. A given collation implies the ...Number Hex Character Set Name 8 0x08 latin1_swedish_ci 33 0x21 utf8_general_ci 63 0x3f binary Protocol::CharacterSet A character set is defined in the protocol as a ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
This means they have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in the values. Instead, it causes the binary (_bin) collation for the column character set (or the table default ...