:: DEVELOPER ZONE
MySQL Reference Manual :: 10 Character Set Support
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 6 Replication in MySQL
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 10.1 Character Sets and Collations in General
- 10.2 Character Sets and Collations in MySQL
- 10.3 Determining the Default Character Set and Collation
- 10.4 Operations Affected by Character Set Support
- 10.5 Unicode Support
- 10.6 UTF8 for Metadata
- 10.7 Compatibility with Other DBMSs
- 10.8 New Character Set Configuration File Format
- 10.9 National Character Set
- 10.10 Upgrading Character Sets from MySQL 4.0
- 10.11 Character Sets and Collations That MySQL Supports
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- 10.1. Character Sets and Collations in General
- 10.2. Character Sets and Collations in MySQL
- 10.3. Determining the Default Character Set and Collation
- 10.3.1. Server Character Set and Collation
- 10.3.2. Database Character Set and Collation
- 10.3.3. Table Character Set and Collation
- 10.3.4. Column Character Set and Collation
- 10.3.5. Examples of Character Set and Collation Assignment
- 10.3.6. Connection Character Sets and Collations
- 10.3.7. Character String Literal Character Set and Collation
- 10.3.8. Using
COLLATEin SQL Statements - 10.3.9.
COLLATEClause Precedence - 10.3.10.
BINARYOperator - 10.3.11. Some Special Cases Where the Collation Determination Is Tricky
- 10.3.12. Collations Must Be for the Right Character Set
- 10.3.13. An Example of the Effect of Collation
- 10.4. Operations Affected by Character Set Support
- 10.5. Unicode Support
- 10.6. UTF8 for Metadata
- 10.7. Compatibility with Other DBMSs
- 10.8. New Character Set Configuration File Format
- 10.9. National Character Set
- 10.10. Upgrading Character Sets from MySQL 4.0
- 10.11. Character Sets and Collations That MySQL Supports
Improved support for character set handling was added to MySQL in Version 4.1. 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.)
This chapter discusses the following topics:
What are character sets and collations?
The multiple-level default system
New syntax in MySQL 4.1
Affected functions and operations
Unicode support
The meaning of each individual character set and collation
Character set support currently is included in the
MyISAM, MEMORY
(HEAP), and (as of MySQL 4.1.2)
InnoDB storage engines. The ISAM
storage engine does not include character set support; there are no
plans to change this, because ISAM is deprecated.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.