DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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