kdealba@xxxxxxxx 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
