Thread: Order by and leading spaces

Order by and leading spaces

From
"Emmanuel GUYOT - InCrEG"
Date:
Hi,

I've noticed that the 7.3.3 has a strange behaviour were sorting rows with =
leading spaces. It seems that leadings spaces are ignored.

Anyone has noticed that ? Is there a workaround ?
E.G.

     Emmanuel Guyot
      Co-cr=E9ateur & g=E9rant=20=20
      8 Rue des Mont=E9es
      45100 Orl=E9ans
      France  Phone : [33] (0)2 38 56 42 72
      GSM : [33] (0)6 84 62 81 73
      Email : emmguyot@wanadoo.fr
      ICQ : 6945538=20=20
      Web site : http://www.increg.com=20

Re: Order by and leading spaces

From
Stephan Szabo
Date:
On Sun, 6 Jul 2003, Emmanuel GUYOT - InCrEG wrote:

> I've noticed that the 7.3.3 has a strange behaviour were sorting rows
> with leading spaces. It seems that leadings spaces are ignored.

Are you in "C" locale or some other locale and on what OS?  Some (many?)
OS locale definitions have collation rules that ignore spaces and/or
symbols.  For example, on my redhat box in en_US locale, " b" > "a".