Re: Compare chinese words

 

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