Thread

1. Order by and leading spaces

   Emmanuel GUYOT - InCrEG <emmguyot@wanadoo.fr> — 2003-07-06T16:05:22Z

   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éateur & gérant  
         8 Rue des Montées
         45100 Orléans
         France  Phone : [33] (0)2 38 56 42 72
         GSM : [33] (0)6 84 62 81 73
         Email : emmguyot@wanadoo.fr
         ICQ : 6945538  
         Web site : http://www.increg.com 
   

2. Re: Order by and leading spaces

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2003-07-06T17:37:52Z

   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".