Re: [ADMIN] PostgreSQL encoding question - Mailing list pgsql-general

From Lamar Owen
Subject Re: [ADMIN] PostgreSQL encoding question
Date
Msg-id 39E36170.9F96A76C@wgcr.org
Whole thread Raw
In response to PostgreSQL encoding question  ("Anton Kalauzky" <kalauzky@hotmail.com>)
List pgsql-general
Anton Kalauzky wrote:
[Problem with sort order in RH 6.1 upgraded to 6.2 versus straight 6.2
install]

> So, do you have any idea about solving this problem? Thank you for your
> time.

This is due to the collation sequence set up in RH 6.2 when you do a
fresh install.  The upgrade doesn't touch the file in question,
/etc/sysconfig/i18n.  Copy this file as it is from the fresh RH 6.2
install over to the upgraded RH 6.1 install and see what happens.

Red Hat changed, for better or for worse, the collation in RH 6.2 and
later to more closely conform to ISO standards.

Ask on pgsql-hackers, or directly e-mail teg@redhat.com for more
details.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Curious age() behavior Cont'd
Next
From: Marc SCHAEFER
Date:
Subject: Re: Some advanced database features, are they present in PostgreSQL