> I have a problem to use the postgresql DBMS.
> When to sort(order by clause) texts data encoded in UTF-8, it retrieved as non-ordered data.
> When to sort(order by clause) texts data encoded in the korean codes(EUR-KR), it retrieved as ordered data.
> I wonder why it worked badly.
> Do we need to set up any other variables to do it??
>
> The postgresql DBMS is like this :
> ver 7.2, OS : linux-korean
I assume your PostgreSQL is compiled with --enable-locale. Re-install
PostgreSQL without the option and re-initdb should help.
--
Tatsuo Ishii