Обсуждение: 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.

От
"강원석\(Kang Wonseok\)"
Дата:
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

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

От
Tatsuo Ishii
Дата:
> 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