Postgres Pro
Downloads
Home   >   mailing lists

Postgres and special character - Mailing list pgsql-general

From Eric, Audet
Subject Postgres and special character
Date
Msg-id 2DA31E03197FD51192260000F8036F8709DD35@server02
Whole thread Raw
Responses Re: Postgres and special character  (Fernando Schapachnik <fschapachnik@vianetworks.com.ar>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: SELECT FOR UPDATE
Next
From: Fernando Schapachnik
Date:
Subject: Re: Postgres and special character