>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
>
>
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.
Regards,
Tomasz Myrta