Re: A Chinese handling bug

>     We are developing softwares with the PostgresSQL
> database. We met a big problem in Chinese handling.
> Please see the attached states.gif. You can see very
> clear from it. We think this is a bug of the database.
>     Could you please check this bug as soon as possible
> and do the fixing job.

I see the problem, that = 'Chinese' does not return the same rows as
LIKE 'Chinese'.  Certainly seems like a bug, and one that would appear
for other character sets as well.

What version of PostgreSQL are you running?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026