When to sort texts data encoded in UTF-8, retrieve as non-ordered data.
Dear, Postresql master
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
Best regards
WonSeok Kang
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