(mysql.info) charset
Info Catalog
(mysql.info) language-structure
(mysql.info) Top
(mysql.info) data-types
10 Character Set Support
************************
Menu
* charset-general Character Sets and Collations in General
* charset-mysql Character Sets and Collations in MySQL
* charset-syntax Specifying Character Sets and Collations
* charset-connection Connection Character Sets and Collations
* charset-collations Collation Issues
* charset-operations Operations Affected by Character Set Support
* charset-unicode Unicode Support
* charset-metadata UTF-8 for Metadata
* charset-charsets Character Sets and Collations That MySQL Supports
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. MySQL supports the use of character
sets for the `MyISAM', `MEMORY', `NDBCluster', and `InnoDB' storage
engines.
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
Character set issues affect 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 character set-related issues in
client/server communication, see charset-connection.
Info Catalog
(mysql.info) language-structure
(mysql.info) Top
(mysql.info) data-types
automatically generated byinfo2html