Thread: Postgres and special character

Postgres and special character

From
"Eric, Audet"
Date:
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

Re: Postgres and special character

From
Fernando Schapachnik
Date:
You should recompile with the correct locale, I guess.

En un mensaje anterior, Eric, Audet escribió:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl



Fernando P. Schapachnik
Planificación de red y tecnología
VIA NET.WORKS ARGENTINA S.A.
fschapachnik@vianetworks.com.ar
Tel.: (54-11) 4323-3381