Simon Moses wrote:
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
Sorting is down to your locale (the LC_xxx configuration settings). This
is set when you initdb your database. It looks to me like you want "C"
s
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.
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
how to achieve this.
thanks in advance.
-Simon Moses.
=
**
Visit My Home Page
http://www.geocities.com/ks_moses
updated: 28 Sep 2004
