Re: [SQL] Sort order with spaces?

2003-09-17 Thread Kristian Jörg
Tom and Richard, I have successfully fixed this problem now thanks to your support! The setting of LC_COLLATE to C prior to running initdb fixed all problems finally once I had sorted out my error in passing the environment variables correctly. Thanx! /Kristian Kristian Jörg wrote

Re: [SQL] Sort order with spaces?

2003-09-17 Thread Kristian Jörg
It is possible my locale settings did not get through to initdb since I tried using the startup postgres command in /etc/init.d (with som modifications of course). I will try again manually this time! Regards Kristian . -- \\|// (@ @) +--ooO--(_)--Ooo------+-

Re: [SQL] Sort order with spaces?

2003-09-17 Thread Kristian Jörg
Kristian Jörg wrote: Richard Huxton wrote: On Wednesday 17 September 2003 10:47, Kristian Jörg wrote: Hello! I am having troubles with sort order in Postgres. It seems that space is not handled at all? For instance the following rows are sorted in MS SQL

Re: [SQL] Sort order with spaces?

2003-09-17 Thread Kristian Jörg
Richard Huxton wrote: On Wednesday 17 September 2003 10:47, Kristian Jörg wrote: Hello! I am having troubles with sort order in Postgres. It seems that space is not handled at all? For instance the following rows are sorted in MS SQL Server as: LUNDGREN M L R MACDOWELL MUSCLE

[SQL] Sort order with spaces?

2003-09-17 Thread Kristian Jörg
considered at all so "M L R" is interpreted as "MLR" i Postgres. This is a problem for me taht I need to resolve. How do I do that? Regards Kristian -- \\|// (@ @) +--ooO--(_)--Ooo--+------+ | Kristian Jörg |