Re: Ordering in SELECT statement

kdealba@uaaan.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