12.8 Collation Issues

12.8.1 Using COLLATE in SQL Statements

12.8.2 COLLATE Clause Precedence

12.8.3 Character Set and Collation Compatibility

12.8.4 Collation Coercibility in Expressions

12.8.5 The binary Collation Compared to _bin Collations

12.8.6 Examples of the Effect of Collation

12.8.7 Using Collation in INFORMATION_SCHEMA Searches

The following sections discuss various aspects of character set collations.