Chapter 23. Localization Table of Contents 23.1. Locale Support 23.1.1. Overview 23.1.2. Behavior 23.1.3. Selecting Locales 23.1.4. Locale Providers 23.1.5. ICU Locales 23.1.6. Problems 23.2. Collation Support 23.2.1. Concepts 23.2.2. Managing Collations 23.2.3. ICU Custom Collations 23.3. Character Set Support 23.3.1. Supported Character Sets 23.3.2. Setting the Character Set 23.3.3. Automatic Character Set Conversion Between Server and Client 23.3.4. Available Character Set Conversions 23.3.5. Further Reading This chapter describes the available localization features from the point of view of the administrator. PostgreSQL supports two localization facilities: * Using the locale features of the operating system to provide locale-specific collation order, number formatting, translated messages, and other aspects. This is covered in Section 23.1 and Section 23.2. * Providing a number of different character sets to support storing text in all kinds of languages, and providing character set translation between client and server. This is covered in Section 23.3.