order by - Mailing list pgsql-general

From Adrian Perez Camarena
Subject order by
Date
Msg-id 200002291856.MAA15944@ife.org.mx
Whole thread Raw
Responses Re: [GENERAL] order by  (Oleg Broytmann <phd@phd.russ.ru>)
List pgsql-general
Hello friends
I have the next problem :
I need to order by name a table that contains name and other
fields of users.
I'm in Mexico city and the user's name looks like these:

Select name from prueba_insaculacion order by name;

name
--------------
BELTRAN
DIAZ
HAVEZ
LLUNAS
LOPEZ
NA�ES
NU�EZ
PEREZ
PE�A
YA�ES
�RSATE
�AURIBIA
�NAMUNO

as you can see the order by name is wrong,
mi question is the next:

is there a file of postgres that I can change to tell postgres
that the language that I need to order by name correctly is
spanish? (or something like that)

thanks for your help...

Adrian Perez
IFE


pgsql-general by date:

Previous
From: davidb@vectormath.com
Date:
Subject: Would like to install on NT Workstation
Next
From: "Steve Wolfe"
Date:
Subject: "LockRelease: locktable lookup failed, no lock"