MySQL 5.1 Reference Manual :: 9 Internationalization and Localization :: 9.1 Character Set Support :: 9.1.7 Collation Issues
Section Navigation [Toggle]
- 9.1 Character Set Support
- 9.1.1 Character Sets and Collations in General
- 9.1.2 Character Sets and Collations in MySQL
- 9.1.3 Specifying Character Sets and Collations
- 9.1.4 Connection Character Sets and Collations
- 9.1.5 Configuring the Character Set and Collation for Applications
- 9.1.6 Character Set for Error Messages
- 9.1.7 Collation Issues
- 9.1.7.1 Using COLLATE in SQL Statements
- 9.1.7.2 COLLATE Clause Precedence
- 9.1.7.3 The BINARY Operator
- 9.1.7.4 The _bin and binary Collations
- 9.1.7.5 Special Cases Where Collation Determination Is Tricky
- 9.1.7.6 Collations Must Be for the Right Character Set
- 9.1.7.7 Examples of the Effect of Collation
- 9.1.7.8 Collation and INFORMATION_SCHEMA Searches
- 9.1.8 String Repertoire
- 9.1.9 Operations Affected by Character Set Support
- 9.1.10 Unicode Support
- 9.1.11 UTF-8 for Metadata
- 9.1.12 Column Character Set Conversion
- 9.1.13 Character Sets and Collations That MySQL Supports
[+/-]
- 9.1.7.1. Using
COLLATEin SQL Statements - 9.1.7.2.
COLLATEClause Precedence - 9.1.7.3. The
BINARYOperator - 9.1.7.4. The
_binandbinaryCollations - 9.1.7.5. Special Cases Where Collation Determination Is Tricky
- 9.1.7.6. Collations Must Be for the Right Character Set
- 9.1.7.7. Examples of the Effect of Collation
- 9.1.7.8. Collation and
INFORMATION_SCHEMASearches
The following sections discuss various aspects of character set collations.
User Comments
Add your own comment.