Mega Code Archive

 

Categories / MySQL / Internationalization

 

COLLATE utf8_romanian_ci for column definition

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