Columns with CHAR, VARCHAR, or TEXT data types have collations.
Numeric and other non-character types have no collation (indicated by NULL as the Collation value).
mysql>mysql>mysql>mysql>mysql> CREATE TABLE myTable -> ( -> c1 CHAR(10) -> ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci;Query OK, 0 rows affected (0.03 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 FULL COLUMNS FROM myTableG*************************** 1. row *************************** Field: c1 Type: char(10) Collation: latin1_danish_ci Null: YES Key: Default: NULL Extra:Privileges: select,insert,update,references Comment:1 row in set (0.00 sec)mysql>mysql> drop table myTable;Query OK, 0 rows affected (0.00 sec)mysql>
Name (required)
email (will not be published) (required)
Website