7 Aug 2011
To discover the character set and collation of a database, just
USE your_database_of_interest;
and type,
show variables like "character_set_database";
show variables like "collation_database";
http://dev.mysql.com/doc/refman/5.0/en/charset-database.html