Re: Ordering in SELECT statement

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