8.3 Determining The Default Character Set And Collation

There are default settings for character sets and collations at four levels: server, database, table, connection. The following description may appear complex, but it's been found in practice that multi-level defaulting leads to natural and obvious results.

Subsections

• 8.3.1 Server Character Set and Collation
• 8.3.2 Database Character Set and Collation
• 8.3.3 Table Character Set and Collation
• 8.3.4 Column Character Set and Collation
• 8.3.5 Examples of Character Set and Collation Assignment
• 8.3.6 Connection Character Sets and Collations
• 8.3.7 Character String Literal Character Set and Collation
• 8.3.8 COLLATE Clause in Various Parts of an SQL Query
• 8.3.9 COLLATE Clause Precedence
• 8.3.10 BINARY Operator
• 8.3.11 Some Special Cases Where the Collation Determination is Tricky
• 8.3.12 Collations Must Be for the Right Character Set
• 8.3.13 An example of the Effect of Collation

User Comments

Add your own comment.