When to sort texts data encoded in UTF-8, retrieve as non-ordered data.

From: 강원석\(Kang Wonseok\) <wskang(at)world(dot)kaist(dot)ac(dot)kr>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: When to sort texts data encoded in UTF-8, retrieve as non-ordered data.
Date: 2003-04-08 07:00:41
Message-ID: 000d01c2fd9c$91b21d90$1987f88f@sysx2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Christoph_Becker 2003-04-08 07:39:50 ERROR: heap_mark4update: (am)invalid tid, after the 14th update in 7.3.2
Previous Message Venkataseshareddy.Gotham 2003-04-08 06:15:39 FW: sql exception problem