order by accents?

From: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: order by accents?
Date: 2000-07-07 16:53:51
Message-ID: 39660B1F.CD9B9EF2@mediacces.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-07 17:12:59 Re: Re: [SQL] MAX() of 0 records.
Previous Message Robert B. Easter 2000-07-07 16:53:27 Re: Re: [HACKERS] Re: [SQL] MAX() of 0 records.