It's because of locales. Some special characteres are removed when sorting using locales. I'm not sure, but probably only "C" locale will give results you need.dear sir, when i run a query with order by customer_name i am getting the following result(ex.).
AA A B AC
i want it to be
A B
AA
AB
Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
