↑↓ 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.4 reached end of support in July 2014. See the current version for supported releases.
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

Report a documentation issue

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