Set COLLATE=latin1_german1_ci : Collate « I18N « SQL / MySQL






  1. SQL / MySQL
  2. I18N
  3. Collate

Set COLLATE=latin1_german1_ci

   
mysql>
mysql> CREATE TABLE categories (
    ->   catID int(11) NOT NULL auto_increment,
    ->   PRIMARY KEY  (catID)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql> drop table categories;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>








Related examples in the same category

1.ORDER BY and COLLATE latin1_german2_ci
2.ALTER TABLE employee MODIFY employee VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_german2_ci;
3.ORDER BY CONVERT(firstname USING utf8) COLLATE utf8_polish_ci;
4.SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_general_ci
5.SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_german1_ci
6.SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_swedish_ci
7.SELECT firstname FROM employee ORDER BY firstname COLLATE utf8_general_ci
8.COLLATE sort operator allows you ro specify a collation in your expression.
9.Create database with character set and collate
10.Change the character set name and collate name for database
11.Change collate for database
12.COLLATE utf8_romanian_ci for column definition
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 '='