COLLATION(str) returns the collation of the string argument. : COLLATION « Information Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Information Functions
  3. COLLATION
mysql>
mysql> SELECT COLLATION('abc');
+-------------------+
| COLLATION('abc')  |
+-------------------+
| latin1_swedish_ci |
+-------------------+
1 row in set (0.00 sec)








20.5.COLLATION
20.5.1.COLLATION(str) returns the collation of the string argument.
20.5.2.SELECT COLLATION(_utf8'abc');