Compare chinese words

From: "oclam" <oc(dot)lam(at)innoage(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Compare chinese words
Date: 2002-09-10 05:46:59
Message-ID: 022c01c2588d$7aed4bc0$0a01a8c0@oclam
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Jore 2002-09-10 07:16:51 Psql regex is NFA or DFA?
Previous Message Jong-won Choi 2002-09-10 04:06:09 nextval result type difference between 7.1.3 and 7.2.1