COLLATE utf8_romanian_ci for column definition : Collate « I18N « SQL / MySQL






  1. SQL / MySQL
  2. I18N
  3. Collate

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>








Related examples in the same category

1.Set COLLATE=latin1_german1_ci
2.ORDER BY and COLLATE latin1_german2_ci
3.ALTER TABLE employee MODIFY employee VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_german2_ci;
4.ORDER BY CONVERT(firstname USING utf8) COLLATE utf8_polish_ci;
5.SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_general_ci
6.SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_german1_ci
7.SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_swedish_ci
8.SELECT firstname FROM employee ORDER BY firstname COLLATE utf8_general_ci
9.COLLATE sort operator allows you ro specify a collation in your expression.
10.Create database with character set and collate
11.Change the character set name and collate name for database
12.Change collate for database
13.Set the character set and collate for a table
14.COLLATE 'latin1_danish_ci'
15.ORDER BY a column COLLATE latin1_swedish_ci
16.Cast COLLATE
17.Order by collate
18.Alter table to change the collate setting
19.Check the collation name
20.Get collation
21.ERROR 1267 (HY000): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_danish_ci,IMPLICIT) for operation '='