PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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/refman/8.0/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.0/en/upgrading-from-previous-series.html
The default value of the collation_server and collation_database system variables has changed from latin1_swedish_ci to utf8mb4_0900_ai_ci. As a result, the default character set and collation for new objects differ from previously unless an ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0 interprets length specifications in character ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...