Postgres and special character

From: "Eric, Audet" <eaudet(at)scc(dot)ca>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres and special character
Date: 2001-08-23 13:43:40
Message-ID: 2DA31E03197FD51192260000F8036F8709DD35@server02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In my database I have french character

When I do "select * from customer order by firstname"

I get result in this order
Eric
Ezeb
Isabelle
Ziggy
Éric
Éve

But would like to get
Eric
Éric
Éve
Ezeb
Isabelle
Ziggy

In other word, I would like É be considered like a E ... the same goes with
ÀÛÊ etc etc

Is there a way to do this?

Eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Snow 2001-08-23 13:49:52 RE: Re: SELECT FOR UPDATE
Previous Message Gregory Wood 2001-08-23 13:38:59 Re: SELECT FOR UPDATE