From: | Doug Gorley <doug(dot)gorley(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Different sort order btwn Linux and Windows |
Date: | 2011-04-27 20:35:27 |
Message-ID: | BANLkTi=JB=zRPiNh1ZcH-E8ig+uVDnmmWQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
That does indeed appear to be the case -- the database on the Linux server
has en_CA.UTF-8 collation, while the database on the Windows server has
English_Canada.1252 collation. Thanks!
Doug
On Wed, Apr 27, 2011 at 1:04 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 27 April 2011 20:28, Doug Gorley <doug(dot)gorley(at)gmail(dot)com> wrote:
>
>> I'm running the following SQL commands on a new PostgreSQL 9.0 database,
>> one on Linux, one on Windows.
>>
>> create table i (j varchar(4));
>> insert into i (j) values ('A'), ('E'), ('<C P'), ('F');
>> select j from i order by j asc;
>>
>> On the Windows server I get the following:
>>
>> ----
>> <C P
>> A
>> E
>> F
>> ----
>>
>> On the Linux server, I get this instead:
>>
>> ----
>> A
>> <C P
>> E
>> F
>> ----
>>
>> Can anyone tell me why the sort order would come out differently?
>>
>>
> The collations are different on your two databases.
>
> Try:
>
> SHOW lc_collate;
>
> --
> Thom Brown
> Twitter: @darkixion
> IRC (freenode): dark_ixion
> Registered Linux user: #516935
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
--
Doug Gorley | doug(dot)gorley(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Mark | 2011-04-27 20:55:51 | GIN index not used |
Previous Message | Merlin Moncure | 2011-04-27 20:17:45 | Re: [HACKERS] PostgreSQL Core Team |