To find out what collation and character set your database is using turns out to be pretty trivial thanks to MySQL's SHOW VARIABLES SQL statement...