The available character sets, use the SHOWĬHARACTER SET statement. The MySQL server can support multiple character sets. Multiple-character mappings (such as the rule thatġ1.1.2 Character Sets and Collations in MySQL Rules, not just for whether to distinguish lettercase, but alsoįor whether to distinguish accents (an “ accent” isĪ mark attached to a character as in German Also in real life, most collations have many Thousands of characters, along with many special symbols and Sometimes multiple alphabets or eastern writing systems with In real life, most character sets have many characters: not just It is a little more complex than a binary collation. Letters are equivalent? Then we would have at least two rules:Ĭollation. Of rules (only one rule in this case): “ compare theĮncodings.” We call this simplest of all possibleīut what if we want to say that the lowercase and uppercase Suppose that we want to compare two string values,Īpply a collation to our character set. Suppose that we have an alphabet with four letters: The distinction clear with an example of an imaginary character Rules for comparing characters in a character set. This chapter discusses the following topics:ġ1.1.1 Character Sets and Collations in General Supports the use of character sets for the
Sets at the server, database, table, and column level.
MySQL includes character set support that enables you to storeĭata using a variety of character sets and perform comparisonsĪccording to a variety of collations. Use) and localization (selecting particular local conventions):ġ1.1.1 Character Sets and Collations in General 11.1.2 Character Sets and Collations in MySQL 11.1.3 Collation Naming Conventions 11.1.4 Specifying Character Sets and Collations 11.1.5 Connection Character Sets and Collations 11.1.6 Configuring the Character Set and Collation for Applications 11.1.7 Character Set for Error Messages 11.1.8 Collation Issues 11.1.9 String Repertoire 11.1.10 Operations Affected by Character Set Support 11.1.11 Unicode Support 11.1.12 Upgrading from Previous to Current Unicode Support 11.1.13 UTF-8 for Metadata 11.1.14 Column Character Set Conversion 11.1.15 Character Sets and Collations Supported by MySQL Internationalization (MySQL's capabilities for adapting to local This chapter covers issues of globalization, which includes Table of Contents 11.1 Character Set Support 11.1.1 Character Sets and Collations in General 11.1.2 Character Sets and Collations in MySQL 11.1.3 Collation Naming Conventions 11.1.4 Specifying Character Sets and Collations 11.1.5 Connection Character Sets and Collations 11.1.6 Configuring the Character Set and Collation for Applications 11.1.7 Character Set for Error Messages 11.1.8 Collation Issues 11.1.9 String Repertoire 11.1.10 Operations Affected by Character Set Support 11.1.11 Unicode Support 11.1.12 Upgrading from Previous to Current Unicode Support 11.1.13 UTF-8 for Metadata 11.1.14 Column Character Set Conversion 11.1.15 Character Sets and Collations Supported by MySQL 11.2 Setting the Error Message Language 11.3 Adding a Character Set 11.3.1 Character Definition Arrays 11.3.2 String Collating Support for Complex Character Sets 11.3.3 Multi-Byte Character Support for Complex Character Sets 11.4 Adding a Collation to a Character Set 11.4.1 Collation Implementation Types 11.4.2 Choosing a Collation ID 11.4.3 Adding a Simple Collation to an 8-Bit Character Set 11.4.4 Adding a UCA Collation to a Unicode Character Set 11.5 Character Set Configuration 11.6 MySQL Server Time Zone Support 11.6.1 Staying Current with Time Zone Changes 11.6.2 Time Zone Leap Second Support 11.7 MySQL Server Locale Support
0 kommentar(er)
