Re: Sorting Issue

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: emilu@encs.concordia.ca; pgsql-sql@postgresql.org
Subject: RE: [SQL] Sorting Issue

The collate setting is  LC_COLLATE = 'English_United States.1252'

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, May 09, 2011 2:29 PM
To: Samuel Gendler
Cc: emilu@encs.concordia.ca; Ozer, Pam; pgsql-sql@postgresql.org
Subject: Re: [SQL] Sorting Issue

Samuel Gendler <sgendler@ideasculptor.com> 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