Re: Compare chinese words

Поиск
Список
Период
Сортировка
От oclam
Тема Re: Compare chinese words
Дата
Msg-id 00b501c2593c$c6157500$0a01a8c0@oclam
обсуждение исходный текст
Ответ на Compare chinese words  ("oclam" <oc.lam@innoage.com>)
Список pgsql-general
Дерево обсуждения
Is there anything needed to be set in the database?
 
The database return TRUE when I execute the following statement :
    SELECT chr(182)=chr(167);
 
But it return FALSE if I changed the statement to:
    SELECT chr(182)=chr(100);
 
I've try to change the database encoding to 'EUC_TW', 'LATIN1', and 'WIN'. However, the problem still exists.
Any suggestion on what I can do?
----- Original Message -----
From: wlj
To: oclam
Sent: Wednesday, September 11, 2002 9:16 AM
Subject: Re: [GENERAL] Compare chinese words

i try it in japanese,i got the result that you wanted.
----- Original Message -----
From: oclam
Sent: Tuesday, September 10, 2002 1:46 PM
Subject: [GENERAL] Compare chinese words

Hi,
 
I'm a new user of PostgreSQL. I wrote the following statement to compare 2 Chinese words if they are the same :
 
 SELECT '黃'='李';
 
(
    For those who cannot read Chinese, can use the following statement : 
        SELECT (chr(182) || chr(192))=(chr(167) || chr(245));
)
 
I expected it will return false to me, but it return true.
Can anyone help me to solve this? Thx.
 
oclam

В списке pgsql-general по дате отправления: