Postgres and special character

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