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

From teg@redhat.com (Trond Eivind Glomsrød)
Subject Re: Re: [ADMIN] PostgreSQL encoding question
Date
Msg-id xuy8zrwh6uk.fsf@hoser.devel.redhat.com
Whole thread Raw
In response to PostgreSQL encoding question  ("Anton Kalauzky" <kalauzky@hotmail.com>)
List pgsql-general
Lamar Owen <lamar.owen@wgcr.org> writes:

> 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.

I'm reading here, and what Lamar's saying is correct.

--
Trond Eivind Glomsrød
Red Hat, Inc.

pgsql-general by date:

Previous
From: "chris markiewicz"
Date:
Subject: TEXT vs VARCHAR
Next
From: Michael Alan Dorman
Date:
Subject: Re: [HACKERS] My new job