peter pilsl wrote:
>
> I just get my mind crossed here:
>
> I do a simple select with order on a text-type. In my opinion entries
> with leading spaces should be either first (or maybe last) in the list.
> But in my select the whitespace just seems to be ignored:
That'll be down to your locale settings. You'll need to re-initdb to
change them I'm afraid. It's locale=C that you want.
--
Richard Huxton
Archonet Ltd