[BUGS] BUG #1721: mutiple bytes character string comaprison error

[Chii-Tung Liu]

The following bug has been logged online:

Bug reference:      1721
Logged by:          Chii-Tung Liu
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system:   Windows XP SP2
Description:        mutiple bytes character string comaprison error
Details: 

When compare two UTF-8 encoded string that contains Chinese words, the
result is always TRUE
1. create a database test with encoding set to unicode
CREATE DATABASE test
  WITH OWNER = postgres
       ENCODING = 'UNICODE'
       TABLESPACE = pg_default;
2. insert data with Chinese words
INSERT into node set title='1 中æ??'

3. SELECT title from node where title > '1.1 '
would return '1 中æ??'

4. Both SELECT '1 中æ??' > '1.1' and  SELECT '1.1' > '1 中æ??' return
FALSE

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq