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 -----
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 -----
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