Re: Collating Question... - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Collating Question...
Date
Msg-id E212CFF3-4EB5-4011-B3FA-F15278C4CF41@seespotcode.net
Whole thread Raw
In response to Collating Question...  (Jerry LeVan <jerry.levan@eku.edu>)
List pgsql-general
On Jan 16, 2007, at 11:52 , Jerry LeVan wrote:

> The locale function on the mac has everything set to "C"
> and on the linux box it is all "en_US.UTF-8".
>
> Is there a simple way to get the collating sequences to be
> the same on both boxen?

My understanding is that to have the same ordering you need to have
initdb'd with the same locale on both machines. Hopefully PostgreSQL
will have better collation support in the future.

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: Jerry LeVan
Date:
Subject: Collating Question...
Next
From: Chris
Date:
Subject: Re: Improve Postgres Query Speed