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