Information Functions MySQL Tutorial

mysql>
mysql> SELECT COLLATION('abc');
+-------------------+
| COLLATION('abc')  |
+-------------------+
| latin1_swedish_ci |
+-------------------+
1 row in set (0.00 sec)