MySQL 5.5 Reference Manual :: 9 Internationalization and Localization :: 9.1 Character Set Support :: 9.1.7 Collation Issues :: 9.1.7.2 COLLATE Clause Precedence
Section Navigation [Toggle]
- 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
The COLLATE clause has high precedence
(higher than ||),
so the following two expressions are equivalent:
x || y COLLATE z x || (y COLLATE z)
User Comments
Add your own comment.