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