MySQL Manual- 1 General Information
- 2 MySQL Installation
- 3 Tutorial Introduction
- 4 Database Administration
- 5 MySQL Optimisation
- 6 MySQL Language Reference
- 7 MySQL Table Types
- 8 National Character Sets and Unicode in MySQL 4.1
- 8.1 Character Sets and Collations in General
- 8.2 Character Sets and Collations in MySQL
- 8.3 Determining The Default Character Set And Collation
- 8.4 Operations Affected by Character Set Support
- 8.5 Unicode Support
- 8.6 UTF8 for Metadata
- 8.7 Compatibility with Other DBMSs
- 8.8 New Character Set Configuration File format
- 8.9 National Character Set
- 8.10 Upgrading from MySQL 4.0
- 8.11 The Character Sets and Collations that MySQL Supports
- 9 MySQL APIs
- 10 Error Handling in MySQL
- 11 Spatial Extensions in MySQL
- 12 Extending MySQL
- A Problems and Common Errors
- B Contributed Programs
- C Credits
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I GNU Lesser General Public License
- SQL command, type and function index
- Concept Index
8 National Character Sets and Unicode in MySQL 4.1
Improved handling of character sets is one of the features added to MySQL in Version 4.1. This chapter explains:
- What are character sets and collations
- The multi-level default system
- New syntax in MySQL 4.1
- Affected functions and operations
- The meaning of each individual character set and collation
The features described here are as implemented in MySQL 4.1.1. (MySQL 4.1.0 has some but not all of these features, and some of them are implemented differently.)
Subsections
- 8.1 Character Sets and Collations in General
- 8.2 Character Sets and Collations in MySQL
- 8.3 Determining The Default Character Set And Collation
- 8.3.1 Server Character Set and Collation
- 8.3.2 Database Character Set and Collation
- 8.3.3 Table Character Set and Collation
- 8.3.4 Column Character Set and Collation
- 8.3.5 Examples of Character Set and Collation Assignment
- 8.3.6 Connection Character Sets and Collations
- 8.3.7 Character String Literal Character Set and Collation
- 8.3.8
COLLATEClause in Various Parts of an SQL Query - 8.3.9
COLLATEClause Precedence - 8.3.10
BINARYOperator - 8.3.11 Some Special Cases Where the Collation Determination is Tricky
- 8.3.12 Collations Must Be for the Right Character Set
- 8.3.13 An example of the Effect of Collation
- 8.4 Operations Affected by Character Set Support
- 8.4.1 Result Strings
- 8.4.2
CONVERT() - 8.4.3
CAST() - 8.4.4
SHOW CHARACTER SET - 8.4.5
SHOW COLLATION - 8.4.6
SHOW CREATE DATABASE - 8.4.7
SHOW FULL COLUMNS - 8.5 Unicode Support
- 8.6 UTF8 for Metadata
- 8.7 Compatibility with Other DBMSs
- 8.8 New Character Set Configuration File format
- 8.9 National Character Set
- 8.10 Upgrading from MySQL 4.0
- 8.11 The Character Sets and Collations that MySQL Supports
- 8.11.1 The Unicode Character Sets
- 8.11.2 Platform Specific Character Sets
- 8.11.3 Character Sets for South Europe and Middle East
- 8.11.4 The Asian Character Sets
- 8.11.5 The Baltic Character Sets
- 8.11.6 The Cyrillic Character Sets
- 8.11.7 The Central European Character Sets
- 8.11.8 The West European Character Sets
