1.8 Collation Issues

1.8.1 Using COLLATE in SQL Statements

1.8.2 COLLATE Clause Precedence

1.8.3 Character Set and Collation Compatibility

1.8.4 Collation Coercibility in Expressions

1.8.5 The binary Collation Compared to _bin Collations

1.8.6 Examples of the Effect of Collation

1.8.7 Using Collation in INFORMATION_SCHEMA Searches

The following sections discuss various aspects of character set collations.