Re: resend: Chinese sort order problem

Hello Malix,

There are some limitations to multi-byte support. I had the same problems,
see another mail I forwarded.
I am new to the list but I suggest you sent this message to
pgsql-hackers(at)postgresql(dot)org(dot)

Regards,
Jean-Michel POURE

At 15:45 29/10/01 +0800, you wrote:
>hi all,
> I am shade to disturb people here again, but to my Question , i
>have not effective answer.
> it has been suffering me for 3 weeks.
>
> the problem is : How the Postgresql treet the Chinese Text Field
>sort£¨order by£©?
> It seems always false sort order. but the MySQL does this very well.
>
> in my machine "select getdatabaseencoding();" returns "EUC_CN"
> and "\encoding" returns "EUC_CN" too.
> I have tested for "createdb -E EUC_CN / SQL_ASII / LATIN1" ,
> the option "EUC_CN" / "SQL_ASII" results same .
>
> I have also tried recompling the source with "configure
>--enable-locale --enable-multibyte=EUC_CN", it does no help.
>
> So i want to know where is the source code of SQL "ORDER BY", if
>nobody else could help me, I can only choose to
>study the source and solve it by myself.
>
>
>Any suggestion is kind to me.
>Thanks.
>Malix
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org