ALTER TABLE employee MODIFY employee VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_german2_ci; : Collate « I18N « SQL / MySQL

Home
SQL / MySQL
1.Aggregate Functions
2.Backup Load
3.Command MySQL
4.Cursor
5.Data Type
6.Database
7.Date Time
8.Engine
9.Event
10.Flow Control
11.FullText Search
12.Function
13.Geometric
14.I18N
15.Insert Delete Update
16.Join
17.Key
18.Math
19.Procedure Function
20.Regular Expression
21.Select Clause
22.String
23.Table Index
24.Transaction
25.Trigger
26.User Permission
27.View
28.Where Clause
29.XML
SQL / MySQL » I18N » Collate 
ALTER TABLE employee MODIFY employee VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_german2_ci;
   
mysql>
mysql>
mysql>
mysql> CREATE TABLE employee (
    ->     id int unsigned not null auto_increment primary key,
    ->     firstname varchar(20),
    ->     lastname varchar(20),
    ->     title varchar(30),
    ->     age int,
    ->     yearofservice int,
    ->     salary int,
    ->     perks int,
    ->     email varchar(60)
    -> );
Query OK, rows affected (0.01 sec)

mysql>
mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("John""Chen
""Senior Programmer"31312000025000"j@hotmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Jan""Pilla
i""Senior Programmer"32411000020000"g@yahoo.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Ane""Pandi
t""Web Designer"2439000015000"a@gmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Mary""Anch
or""Web Designer"2728500015000"m@mail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Fred""King
""Programmer"3237500015000"f@net.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("John""Mac"
"Programmer"3248000016000"j@hotmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Arthur""Sa
m""Programmer"2827500014000"e@yahoo.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Alok""Nand
a""Programmer"3237000010000"a@yahoo.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Susan""Ra"
"Multimedia Programmer"3249000015000"h@gmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Paul""Simo
n""Multimedia Programmer"2318500012000"ps@gmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Edward""Pa
rhar""Multimedia Programmer"3027500015000"a@hotmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Kim""Hunte
r""Senior Web Designer"32411000020000"kim@coolmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Roger""Lew
is""System Administrator"32310000013000"roger@mail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Danny""Gib
son""System Administrator"3129000012000"danny@hotmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Mike""Harp
er""Senior Marketing Executive"36112000028000"m@gmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Mary""Sund
ay""Marketing Executive"3159000025000"monica@bigmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Jack""Sim"
"Marketing Executive"2717000018000"hal@gmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Joe""Irvin
e""Marketing Executive"2717200018000"joseph@hotmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Henry""Ali
""Customer Service Manager"323700009000"shahida@hotmail.com");
Query OK, row affected (0.00 sec)

mysql> INSERT INTO employee (firstname, lastName, title, age, yearofservice, salary, perks, emailvalues ("Peter""Cha
mpion""Finance Manager"32212000025000"peter@yahoo.com");
Query OK, row affected (0.00 sec)

mysql>
mysql>
mysql>
mysql> ALTER TABLE employee MODIFY firstname VARCHAR(60CHARACTER SET latin1 COLLATE latin1_german2_ci;
Query OK, 20 rows affected (0.01 sec)
Records: 20  Duplicates: 0  Warnings: 0

mysql>
mysql>
mysql> drop TABLE employee;
Query OK, rows affected (0.00 sec)

   
    
    
  
Related examples in the same category
1.Set COLLATE=latin1_german1_ci
2.ORDER BY and 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 '='
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.