10.1.7 Collation Issues

10.1.7.1 Collation Naming Conventions
10.1.7.2 Using COLLATE in SQL Statements
10.1.7.3 COLLATE Clause Precedence
10.1.7.4 Collations Must Be for the Right Character Set
10.1.7.5 Collation of Expressions
10.1.7.6 The _bin and binary Collations
10.1.7.7 The BINARY Operator
10.1.7.8 Examples of the Effect of Collation
10.1.7.9 Collation and INFORMATION_SCHEMA Searches

The following sections discuss various aspects of character set collations.