- 18.104.22.168 Server Character Set and Collation
- 22.214.171.124 Database Character Set and Collation
- 126.96.36.199 Table Character Set and Collation
- 188.8.131.52 Column Character Set and Collation
- 184.108.40.206 Character String Literal Character Set and Collation
- 220.127.116.11 National Character Set
- 18.104.22.168 Examples of Character Set and Collation Assignment
- 22.214.171.124 Compatibility with Other DBMSs
There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results.
CHARACTER SET is used in clauses that specify
a character set.
CHARSET can be used as a
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 character set-related issues in client/server communication, see Section 11.1.5, “Connection Character Sets and Collations”.