MySQL Internationalization 48 codes

  1. Home
  2. MySQL
  3. Internationalization
1 _utf8 modifier
2 ALTER TABLE employee MODIFY employee VARCHAR(60) CHARACTER SET latin1 COLLATE latin1_german2_ci
3 Alter table to change the collate setting
4 Cast COLLATE
5 Change collate for database
6 Change the character set name and collate name for database
7 Change the Character Set of All Text Columns
8 Changing the Character Set
9 CHARACTER SET latin1, CHARACTER SET hp8
10 CHARACTER SET utf8 for column definition
11 Character setting for char type column
12 Check the character set
13 Check the character set name and description
14 Check the character set settings
15 Check the collation name
16 Check the default character set name
17 Check utf8 collation name in INFORMATION_SCHEMA COLLATIONS
18 COLLATE latin1_danish_ci
19 COLLATE sort operator allows you ro specify a collation in your expression
20 COLLATE utf8_romanian_ci for column definition
21 CONVERT(expression USING character set)
22 CREATE DATABASE statement specifies the character set and collation
23 Create database with character set and collate
24 ERROR 1267 (HY000)
25 Exporting with the SELECT INTO OUTFILE Statement
26 Get CHARSET
27 Get collation
28 Get the charset and collation information
29 List all collation utf8 related
30 MySQL Character Set Variables
31 Optionally, you can specify a default character set and sort order
32 ORDER BY a column COLLATE latin1_swedish_ci
33 ORDER BY and COLLATE latin1_german2_ci
34 Order by collate
35 ORDER BY CONVERT(firstname USING utf8) COLLATE utf8_polish_ci
36 SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_general_ci
37 SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_german1_ci
38 SELECT firstname FROM employee ORDER BY firstname COLLATE latin1_swedish_ci
39 SELECT firstname FROM employee ORDER BY firstname COLLATE utf8_general_ci
40 Set COLLATE=latin1_german1_ci
41 Set default character during table definition
42 Set DEFAULT CHARSET=latin1
43 Set the character set and collate for a table
44 Specifying the Character Set of a Character String (Cast Operator)
45 Table with default chartset= latin1
46 The CHARSET() function identifies the character set used for a specified string
47 To change the character set to latin1 for the BookSales database, use the following ALTER DATABASE statement
48 To process UTF-8 data