String MySQL

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