Collations and codepages

From: Raimo Jormakka <raimo(dot)jormakka(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Collations and codepages
Date: 2016-10-18 06:17:40
Message-ID: CAMZtG2uWNmosfEHU9dyC3EZeVFp2rYFQnFeerp_OaeX1+fgK_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2016-10-18 07:30:40 Re: Dump all the indexes/constraints/roles
Previous Message Adrian Klaver 2016-10-18 04:06:04 Re: Dump all the indexes/constraints/roles