Globalization

系统管理员 2022-09-20 15:16 125阅读 0赞

本文转载自：http://dev.mysql.com/doc/refman/5.5/en/globalization.html

# Globalization #

**Table of Contents**     \[[\+/-][-]\]

[10.1 Character Set Support][]      \[[\+/-][-]\]

[10.1.1 Character Sets and Collations in General][] [10.1.2 Character Sets and Collations in MySQL][] [10.1.3 Specifying Character Sets and Collations][] [10.1.4 Connection Character Sets and Collations][] [10.1.5 Configuring the Character Set and Collation for Applications][] [10.1.6 Character Set for Error Messages][] [10.1.7 Collation Issues][] [10.1.8 String Repertoire][] [10.1.9 Operations Affected by Character Set Support][] [10.1.10 Unicode Support][] [10.1.11 Upgrading from Previous to Current Unicode Support][] [10.1.12 UTF-8 for Metadata][] [10.1.13 Column Character Set Conversion][] [10.1.14 Character Sets and Collations That MySQL Supports][]

[10.2 Setting the Error Message Language][] [10.3 Adding a Character Set][]      \[[\+/-][-]\]

[10.3.1 Character Definition Arrays][] [10.3.2 String Collating Support for Complex Character Sets][] [10.3.3 Multi-Byte Character Support for Complex Character Sets][]

[10.4 Adding a Collation to a Character Set][]      \[[\+/-][-]\]

[10.4.1 Collation Implementation Types][] [10.4.2 Choosing a Collation ID][] [10.4.3 Adding a Simple Collation to an 8-Bit Character Set][] [10.4.4 Adding a UCA Collation to a Unicode Character Set][]

[10.5 Character Set Configuration][] [10.6 MySQL Server Time Zone Support][]      \[[\+/-][-]\]

[10.6.1 Staying Current with Time Zone Changes][] [10.6.2 Time Zone Leap Second Support][]

[10.7 MySQL Server Locale Support][]

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.

注：近期参加MySQL运维学习，老师推荐该文章作为学习和技术提高的扩展阅读，先记录到自己的博客中，随后慢慢消化、学习、提高。本文章与“字符集和权限安全”主题相关。

[-]: http://dev.mysql.com/doc/refman/5.5/en/globalization.html#
[10.1 Character Set Support]: http://dev.mysql.com/doc/refman/5.5/en/charset.html
[10.1.1 Character Sets and Collations in General]: http://dev.mysql.com/doc/refman/5.5/en/charset-general.html
[10.1.2 Character Sets and Collations in MySQL]: http://dev.mysql.com/doc/refman/5.5/en/charset-mysql.html
[10.1.3 Specifying Character Sets and Collations]: http://dev.mysql.com/doc/refman/5.5/en/charset-syntax.html
[10.1.4 Connection Character Sets and Collations]: http://dev.mysql.com/doc/refman/5.5/en/charset-connection.html
[10.1.5 Configuring the Character Set and Collation for Applications]: http://dev.mysql.com/doc/refman/5.5/en/charset-applications.html
[10.1.6 Character Set for Error Messages]: http://dev.mysql.com/doc/refman/5.5/en/charset-errors.html
[10.1.7 Collation Issues]: http://dev.mysql.com/doc/refman/5.5/en/charset-collations.html
[10.1.8 String Repertoire]: http://dev.mysql.com/doc/refman/5.5/en/charset-repertoire.html
[10.1.9 Operations Affected by Character Set Support]: http://dev.mysql.com/doc/refman/5.5/en/charset-operations.html
[10.1.10 Unicode Support]: http://dev.mysql.com/doc/refman/5.5/en/charset-unicode.html
[10.1.11 Upgrading from Previous to Current Unicode Support]: http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-upgrading.html
[10.1.12 UTF-8 for Metadata]: http://dev.mysql.com/doc/refman/5.5/en/charset-metadata.html
[10.1.13 Column Character Set Conversion]: http://dev.mysql.com/doc/refman/5.5/en/charset-conversion.html
[10.1.14 Character Sets and Collations That MySQL Supports]: http://dev.mysql.com/doc/refman/5.5/en/charset-charsets.html
[10.2 Setting the Error Message Language]: http://dev.mysql.com/doc/refman/5.5/en/error-message-language.html
[10.3 Adding a Character Set]: http://dev.mysql.com/doc/refman/5.5/en/adding-character-set.html
[10.3.1 Character Definition Arrays]: http://dev.mysql.com/doc/refman/5.5/en/character-arrays.html
[10.3.2 String Collating Support for Complex Character Sets]: http://dev.mysql.com/doc/refman/5.5/en/string-collating.html
[10.3.3 Multi-Byte Character Support for Complex Character Sets]: http://dev.mysql.com/doc/refman/5.5/en/multi-byte-characters.html
[10.4 Adding a Collation to a Character Set]: http://dev.mysql.com/doc/refman/5.5/en/adding-collation.html
[10.4.1 Collation Implementation Types]: http://dev.mysql.com/doc/refman/5.5/en/charset-collation-implementations.html
[10.4.2 Choosing a Collation ID]: http://dev.mysql.com/doc/refman/5.5/en/adding-collation-choosing-id.html
[10.4.3 Adding a Simple Collation to an 8-Bit Character Set]: http://dev.mysql.com/doc/refman/5.5/en/adding-collation-simple-8bit.html
[10.4.4 Adding a UCA Collation to a Unicode Character Set]: http://dev.mysql.com/doc/refman/5.5/en/adding-collation-unicode-uca.html
[10.5 Character Set Configuration]: http://dev.mysql.com/doc/refman/5.5/en/charset-configuration.html
[10.6 MySQL Server Time Zone Support]: http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html
[10.6.1 Staying Current with Time Zone Changes]: http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
[10.6.2 Time Zone Leap Second Support]: http://dev.mysql.com/doc/refman/5.5/en/time-zone-leap-seconds.html
[10.7 MySQL Server Locale Support]: http://dev.mysql.com/doc/refman/5.5/en/locale-support.html