Re: When to sort texts data encoded in UTF-8, retrieve as

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: wskang(at)world(dot)kaist(dot)ac(dot)kr
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: When to sort texts data encoded in UTF-8, retrieve as
Date: 2003-04-09 02:30:59
Message-ID: 20030409.113059.74754566.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2003-04-09 02:31:05 Re: Conversion on the fly from KOI8-R to WIN1251 is invalid
Previous Message Norman Vine 2003-04-08 20:49:11 missing DLLIMPORT for cpu_index_tuple_cost