Thread: order by
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
On Tue, 29 Feb 2000, Adrian Perez Camarena wrote: > 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) If I do understand your problem, the solution is here - you should recompile Postgres with locale support, and run it with correct locale settings. Look more docs on locale support in Postgres sourses and documentation. Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they just GOSUB without RETURN.