Chapter 24. Localization

Table of Contents

24.1. Locale Support

24.1.1. Overview

24.1.2. Behavior

24.1.3. Problems

24.2. Collation Support

24.2.1. Concepts

24.2.2. Managing Collations

24.3. Character Set Support

24.3.1. Supported Character Sets

24.3.2. Setting the Character Set

24.3.3. Automatic Character Set Conversion Between Server and Client

24.3.4. Available Character Set Conversions

24.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 24.1 and Section 24.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 24.3.