Mega Code Archive
The CHARSET() function identifies the character set used for a specified string
mysql>
mysql> SELECT CHARSET('cats and dogs');
+--------------------------+
| CHARSET('cats and dogs') |
+--------------------------+
| latin1 |
+--------------------------+
1 row in set (0.00 sec)