Re: Collating Question...

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Jerry LeVan <jerry(dot)levan(at)eku(dot)edu>
Cc: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Collating Question...
Date: 2007-01-16 03:08:19
Message-ID: E212CFF3-4EB5-4011-B3FA-F15278C4CF41@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2007-01-16 04:19:11 Re: Improve Postgres Query Speed
Previous Message Jerry LeVan 2007-01-16 02:52:56 Collating Question...