MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
The COLLATE clause has high precedence
(higher than ||), so
the following two expressions are equivalent:
x || y COLLATE z x || (y COLLATE z)