10.1.7 Collation Issues

10.1.7.1 Collation Names
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.