Thread: When to sort texts data encoded in UTF-8, retrieve as non-ordered data.
When to sort texts data encoded in UTF-8, retrieve as non-ordered data.
From
"강원석\(Kang Wonseok\)"
Date:
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