Documentation Home
MySQL Globalization
Related Documentation Download this Excerpt
PDF (US Ltr) - 455.3Kb
PDF (A4) - 455.2Kb
HTML Download (TGZ) - 89.7Kb
HTML Download (Zip) - 92.4Kb

MySQL Globalization  /  Character Sets, Collations, Unicode

Chapter 1 Character Sets, Collations, Unicode

Table of Contents     [+/-]

1.1 Character Sets and Collations in General
1.2 Character Sets and Collations in MySQL     [+/-]
1.3 Specifying Character Sets and Collations     [+/-]
1.4 Connection Character Sets and Collations
1.5 Configuring Application Character Set and Collation
1.6 Error Message Character Set
1.7 Column Character Set Conversion
1.8 Collation Issues     [+/-]
1.9 Unicode Support     [+/-]
1.10 Supported Character Sets and Collations     [+/-]
1.11 Setting the Error Message Language
1.12 Adding a Character Set     [+/-]
1.13 Adding a Collation to a Character Set     [+/-]
1.14 Character Set Configuration
1.15 MySQL Server Locale Support

MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. You can specify character sets at the server, database, table, and column level.

This chapter discusses the following topics:

  • What are character sets and collations?

  • The multiple-level default system for character set assignment.

  • Syntax for specifying character sets and collations.

  • Affected functions and operations.

  • Unicode support.

  • The character sets and collations that are available, with notes.

  • Selecting the language for error messages.

  • Selecting the locale for day and month names.

Character set issues affect not only data storage, but also communication between client programs and the MySQL server. If you want the client program to communicate with the server using a character set different from the default, you'll need to indicate which one. For example, to use the utf8 Unicode character set, issue this statement after connecting to the server:

SET NAMES 'utf8';

For more information about configuring character sets for application use and character set-related issues in client/server communication, see Section 1.5, “Configuring Application Character Set and Collation”, and Section 1.4, “Connection Character Sets and Collations”.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.