Cast COLLATE : Collate « I18N « SQL / MySQL






  1. SQL / MySQL
  2. I18N
  3. Collate

Cast COLLATE

   
mysql>
mysql> CREATE TABLE LETTERS
    ->    (SEQNO    INTEGER NOT NULL PRIMARY KEY,
    ->     LETTER   CHAR(1) CHARACTER SET UTF8 NOT NULL)
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> -- insert data ;

mysql> SELECT   LETTER, COUNT(*)
    -> FROM    (SELECT   LETTER COLLATE latin2_czech_cs AS LETTER
    ->          FROM     LETTERS) AS LATIN2_CZECH_LETTERS
    -> GROUP BY LETTER
    -> ;
ERROR 1253 (42000): COLLATION 'latin2_czech_cs' is not valid for CHARACTER SET 'utf8'
mysql> SELECT   LETTER, COUNT(*)
    -> FROM    (SELECT   LETTER COLLATE latin2_croatian_ci AS LETTER
    ->          FROM     LETTERS) AS LATIN2_CROATIAN_LETTERS
    -> GROUP BY LETTER;
ERROR 1253 (42000): COLLATION 'latin2_croatian_ci' is not valid for CHARACTER SET 'utf8'
mysql>
mysql> drop table letters;
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.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 '='