Oracle 5.0, Справочное руководство

Страница: 787 / 3232

767
Chapter 10. Globalization
Table of Contents
10.1. Character Set Support ...................................................................................................... 767
10.1.1. Character Sets and Collations in General ................................................................ 768
10.1.2. Character Sets and Collations in MySQL ................................................................ 769
10.1.3. Specifying Character Sets and Collations ................................................................ 770
10.1.4. Connection Character Sets and Collations .............................................................. 776
10.1.5. Configuring the Character Set and Collation for Applications .................................... 778
10.1.6. Character Set for Error Messages .......................................................................... 780
10.1.7. Collation Issues ..................................................................................................... 780
10.1.8. String Repertoire .................................................................................................... 787
10.1.9. Operations Affected by Character Set Support ........................................................ 788
10.1.10. Unicode Support .................................................................................................. 791
10.1.11. UTF-8 for Metadata .............................................................................................. 792
10.1.12. Column Character Set Conversion ........................................................................ 793
10.1.13. Character Sets and Collations That MySQL Supports ............................................ 794
10.2. Setting the Error Message Language ................................................................................ 804
10.3. Adding a Character Set .................................................................................................... 805
10.3.1. Character Definition Arrays ..................................................................................... 807
10.3.2. String Collating Support for Complex Character Sets ............................................... 808
10.3.3. Multi-Byte Character Support for Complex Character Sets ....................................... 808
10.4. Adding a Collation to a Character Set ............................................................................... 808
10.4.1. Collation Implementation Types .............................................................................. 809
10.4.2. Choosing a Collation ID ......................................................................................... 811
10.4.3. Adding a Simple Collation to an 8-Bit Character Set ................................................ 812
10.4.4. Adding a UCA Collation to a Unicode Character Set ................................................ 813
10.5. Character Set Configuration .............................................................................................. 816
10.6. MySQL Server Time Zone Support .................................................................................... 816
10.6.1. Staying Current with Time Zone Changes ............................................................... 819
10.6.2. Time Zone Leap Second Support ........................................................................... 820
10.7. MySQL Server Locale Support .......................................................................................... 821
This chapter covers issues of globalization, which includes internationalization (MySQL's capabilities
for adapting to local use) and localization (selecting particular local conventions):
• MySQL support for character sets in SQL statements.
• How to configure the server to support different character sets.
• Selecting the language for error messages.
• How to set the server's time zone and enable per-connection time zone support.
• Selecting the locale for day and month names.
10.1. Character Set 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. 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?