MySQL Tutorial/Information Functions/COLLATION

COLLATION(str) returns the collation of the string argument.

   <source lang="sql">

mysql> mysql> SELECT COLLATION("abc"); +-------------------+ | COLLATION("abc") | +-------------------+ | latin1_swedish_ci | +-------------------+ 1 row in set (0.00 sec)</source>

SELECT COLLATION(_utf8"abc");

   <source lang="sql">

mysql> mysql> mysql> SELECT COLLATION(_utf8"abc"); +-----------------------+ | COLLATION(_utf8"abc") | +-----------------------+ | utf8_general_ci | +-----------------------+ 1 row in set (0.00 sec)</source>