Internationalization MySQL

mysql>
mysql> CREATE TABLE TABCOLLATE
    ->       (C1   CHAR(10)
    ->             CHARACTER SET utf8
    ->             COLLATE utf8_romanian_ci NOT NULL,
    ->        C2   VARCHAR(10)
    ->             CHARACTER SET utf8
    ->             COLLATE utf8_spanish_ci)
    -> ;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT   COLUMN_NAME, CHARACTER_SET_NAME, COLLATION_NAME
    -> FROM     INFORMATION_SCHEMA.COLUMNS
    -> WHERE    TABLE_NAME = 'TABCOLLATE';
+-------------+--------------------+------------------+
| COLUMN_NAME | CHARACTER_SET_NAME | COLLATION_NAME   |
+-------------+--------------------+------------------+
| C1          | utf8               | utf8_romanian_ci |
| C2          | utf8               | utf8_spanish_ci  |
+-------------+--------------------+------------------+
2 rows in set (0.00 sec)
mysql>
mysql> drop table TABCOLLATE;
Query OK, 0 rows affected (0.00 sec)
mysql>