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>
Name (required)
email (will not be published) (required)
Website