mysql> mysql> CREATE TABLE myTable -> ( -> c1 CHAR(10) -> ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; Query OK, 0 rows affected (0.05 sec) mysql> mysql> desc myTable; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | c1 | char(10) | YES | | NULL | | +-------+----------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> mysql> SHOW CREATE TABLE myTable; +---------+------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+------------------------------------------------------------------------------------------------------------------------------------------------+ | myTable | CREATE TABLE `mytable` ( `c1` char(10) collate latin1_danish_ci default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci | +---------+------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> mysql> drop table myTable; Query OK, 0 rows affected (0.00 sec) mysql> mysql>