Re: Ordering in SELECT statement

[Richard Huxton <dev(at)archonet(dot)com>]

kdealba(at)uaaan(dot)mx wrote:
> 	Hello,
>
> 	I use the following command "SELECT * FROM employees ORDER BY name"
> (a very simple sql statement) the main thing here is that I get a
> list ordered without taking into accound the spaces. For example, I
> get the following listing:
> ABAB
> AB  CD
> ABD  E
> AB  EF
>
> 	and what I need is the following ("old fashion", that is, the
> "SPACE" is another character whose ASCII value is before any other
> LATIN letter's!!)

You'll want to read up on locales - you want the "C" locale. I'm afraid 
it'll mean dumping your database(s) and running initdb again.

--
  Richard Huxton
  Archonet Ltd