Stewart, Brian and myself are having a little fun this morning. One of the niceties of having real UTF8 support in Drizzle is now we can really fun table names. Behold, the glory of Drizzle:

drizzle>> create table ☃ (a int not null);
Query OK, 0 rows affected (0.01 sec)

drizzle>> show create table ☃\G
*************************** 1. row ***************************
       Table: ☃
Create Table: CREATE TABLE `☃` (
  `a` int NOT NULL
) ENGINE=InnoDB
1 row in set (0.00 sec)

Yep, that's a snowman.

MySQL? Well, not so much:

mysql> select @@character_set_system;
+------------------------+
| @@character_set_system |
+------------------------+
| utf8                   | 
+------------------------+
1 row in set (0.00 sec)

mysql> create table ☃ (a int not null);
ERROR 1064 (42000): You have an error in your SQL syntax; \
check the manual that corresponds to your MySQL server version \
for the right syntax to use near '�� (a int not null)' at line 1

/me goes off to record snowman.test.

UPDATE: There isn't an error apparently, in MySQL. As long as you set names UTF8 in the client, all works as expected.