Collations and codepages - Mailing list pgsql-general

From Raimo Jormakka
Subject Collations and codepages
Date
Msg-id CAMZtG2uWNmosfEHU9dyC3EZeVFp2rYFQnFeerp_OaeX1+fgK_g@mail.gmail.com
Whole thread Raw
Responses Re: Collations and codepages
List pgsql-general
Hi all,

In Windows 7, and using PostgreSQL 9.4.5, the collation gets set to "English_United States.1252" when I select the "English, United States" locale in the installer. In Linux, the collation is set to "en_US.UTF-8". The encoding is set to UTF-8 in both instances.

Will these two instances behave identically in terms of collation logic? And if not, is there something I can do about it? In general, what's the impact of the codepage part of a collation to begin with?

Cheers,
Raimo

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Dump all the indexes/constraints/roles
Next
From: Condor
Date:
Subject: Re: Dump all the indexes/constraints/roles