MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 25 total results

12.3.9 Examples of Character Set and Collation Assignment

https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html

Instead, because the default collation for latin1 is always latin1_swedish_ci, column c1 has a collation of latin1_swedish_ci (not latin1_danish_ci). The following examples show how MySQL determines default character set and collation values.

12.14.1 Collation Implementation Types

https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html

MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...

12.14 Adding a Collation to a Character Set

https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html

Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a ...

12.3.3 Database Character Set and Collation

https://dev.mysql.com/doc/refman/8.0/en/charset-database.html

Example: CREATE DATABASE db_name CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL chooses the database character set and database collation in the following manner: If both CHARACTER SET charset_name and COLLATE collation_name are specified, ...

12.13 Adding a Character Set

https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html

<collation name="latin1_swedish_ci" id="8" order="Finnish, Swedish"> <flag>primary</flag> <flag>compiled</flag> </collation> <collation name="latin1_danish_ci" id="15" order="Danish"/> ... This section discusses the procedure for adding a character ...

12.3.5 Column Character Set and Collation

https://dev.mysql.com/doc/refman/8.0/en/charset-column.html

Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...

12.3.1 Collation Naming Conventions

https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html

For example, utf8mb4_0900_ai_ci and latin1_swedish_ci are collations for the utf8mb4 and latin1 character sets, respectively. MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it ...

28.8 Extensions to SHOW Statements

https://dev.mysql.com/doc/refman/8.0/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 ...

14.15 Information Functions

https://dev.mysql.com/doc/refman/8.0/en/information-functions.html

mysql> SELECT COLLATION('abc'); -> 'utf8mb4_0900_ai_ci' mysql> SELECT COLLATION(_utf8mb4'abc'); -> 'utf8mb4_0900_ai_ci' mysql> SELECT COLLATION(_latin1'abc'); -> 'latin1_swedish_ci' CONNECTION_ID() Returns the connection ID (thread ID) for the ...It ...

12.8.6 Examples of the Effect of Collation

https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html

latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...

Displaying 11 to 20 of 25 total results