Re: Compare chinese words - Mailing list pgsql-general

From oclam
Subject Re: Compare chinese words
Date
Msg-id 00f301c25a10$5341e840$0a01a8c0@oclam
Whole thread Raw
In response to Compare chinese words  ("oclam" <oc.lam@innoage.com>)
List pgsql-general
Here is the info.
    postgres (PostgreSQL) 7.2.2
    Red Hat Linux release 7.2
 
what is the version of your postgres and your operating  system??
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?
i try it in japanese,i got the result that you wanted.
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 by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Mailing lists archive search
Next
From: Bruce Momjian
Date:
Subject: SRA contract renewed