Re: Postgres and special character

From: Fernando Schapachnik <fschapachnik(at)vianetworks(dot)com(dot)ar>
To: "Eric, Audet" <eaudet(at)scc(dot)ca>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres and special character
Date: 2001-08-23 13:54:19
Message-ID: 20010823105419.E68105@ns1.via-net-works.net.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)vianetworks(dot)com(dot)ar
Tel.: (54-11) 4323-3381

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2001-08-23 13:55:37 Re: protected ON DELETE CASCADE
Previous Message wsheldah 2001-08-23 13:50:31 How do I drop or change a foreign key?