↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 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
Historical version. PostgreSQL 8.2 reached end of support in December 2011. See the current version for supported releases.
PostgreSQL 8.2.23 Documentation
Prev Fast Backward Fast Forward Next

Chapter 21. Localization

Table of Contents
21.1. Locale Support
21.1.1. Overview
21.1.2. Behavior
21.1.3. Problems
21.2. Character Set Support
21.2.1. Supported Character Sets
21.2.2. Setting the Character Set
21.2.3. Automatic Character Set Conversion Between Server and Client
21.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 defined in the PostgreSQL server, including multiple-byte character sets, to support storing text in all kinds of languages, and providing character set translation between client and server.

Prev Home Next
Authentication problems Up Locale Support

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.