Isn't this the English standard for collation? Or is this a non-c
locale as mentioned below? Is there anyway around this?
LC_COLLATE = 'en_US.utf8'
Thanks
Pam
-----Original Message-----
From: Ozer, Pam
Sent: Monday, May 09, 2011 3:13 PM
To: 'Tom Lane'; Samuel Gendler
Cc: [email protected]; [email protected]
Subject: RE: [SQL] Sorting Issue
The collate setting is
LC_COLLATE = 'English_United States.1252'
-----Original Message-----
From: Tom Lane [mailto:[email protected]]
Sent: Monday, May 09, 2011 2:29 PM
To: Samuel Gendler
Cc: [email protected]; Ozer, Pam; [email protected]
Subject: Re: [SQL] Sorting Issue
Samuel Gendler <[email protected]> writes:
> It's not at all clear why they are not coming out of the db in
> alphabetically sorted order when the query includes "order by
> VehicleTrimAbbreviated asc"
Usually the thing to ask at this point is "what's the database's
LC_COLLATE setting"? Non-C locales often have truly bizarre
sorting rules.
regards, tom lane
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
