ERROR 1267 (HY000): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_danish_ci,IMPLICIT) for operation '=' : Collate « I18N « SQL / MySQL






  1. SQL / MySQL
  2. I18N
  3. Collate

ERROR 1267 (HY000): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_danish_ci,IMPLICIT) for operation '='

       
mysql>
mysql> CREATE TABLE TWOCOLL
    ->       (C1   CHAR(10) COLLATE  'latin1_general_ci' NOT NULL,
    ->        C2   VARCHAR(10) COLLATE 'latin1_danish_ci')
    -> ;
ERROR 1050 (42S01): Table 'twocoll' already exists
mysql> INSERT INTO TWOCOLL VALUES ('A', 'A')
    -> ;
Query OK, 1 row affected (0.00 sec)

mysql> SELECT   *
    -> FROM     TWOCOLL
    -> WHERE    C1 = C2
    -> ;
ERROR 1267 (HY000): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_danish_ci,IMPLICIT) for operation '='
mysql> SELECT   *
    -> FROM     TWOCOLL
    -> WHERE    C1 COLLATE latin1_danish_ci = C2
    -> ;
+----+------+
| C1 | C2   |
+----+------+
| A  | A    |
| A  | A    |
+----+------+
2 rows in set (0.00 sec)

mysql> SELECT   *
    -> FROM     TWOCOLL
    -> WHERE    C1 COLLATE utf8_general_ci = C2;
ERROR 1253 (42000): COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1'
mysql>
mysql> drop table TWOCOLL;
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.COLLATE utf8_romanian_ci for column definition
14.Set the character set and collate for a table
15.COLLATE 'latin1_danish_ci'
16.ORDER BY a column COLLATE latin1_swedish_ci
17.Cast COLLATE
18.Order by collate
19.Alter table to change the collate setting
20.Check the collation name
21.Get collation