Postgres Pro
Downloads
Home   >   mailing lists

order by accents? - Mailing list pgsql-sql

From Patrick Coulombe
Subject order by accents?
Date
Msg-id 39660B1F.CD9B9EF2@mediacces.com
Whole thread Raw
List pgsql-sql
Tree view 
hi,
if I do a query like this one :

SELECT name from medias ORDER BY name

name
----
AAAA
CCCC
EEEE
VVVV
ZZZZ
ÉCCC
----
6 rows


Why the record : ÉCCC is at the end?
HOW can I fix this?

Thank you
Patrick

pgsql-sql by date:

Previous
From: Thomas Swan
Date:
Subject: Altnerate Column Return Names
Next
From: Tom Lane
Date:
Subject: Re: Search for underscore w/ LIKE