November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
PostgreSQL 8.4.22 Documentation
Prev Fast Backward Fast Forward Next

Chapter 22. Localization

Table of Contents
22.1. Locale Support
22.1.1. Overview
22.1.2. Behavior
22.1.3. Problems
22.2. Character Set Support
22.2.1. Supported Character Sets
22.2.2. Setting the Character Set
22.2.3. Automatic Character Set Conversion Between Server and Client
22.2.4. Further Reading

This chapter describes the available localization features from the point of view of the administrator. PostgreSQL supports localization with two approaches:

  • Using the locale features of the operating system to provide locale-specific collation order, number formatting, translated messages, and other aspects.

  • 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.

Prev Home Next
Tablespaces Up Locale Support