Skip site navigation (1) Skip section navigation (2)

BUG #1721: mutiple bytes character string comaprison error

From: "Chii-Tung Liu" <cdliou(at)mail(dot)cyut(dot)edu(dot)tw>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1721: mutiple bytes character string comaprison error
Date: 2005-06-19 11:25:59
Message-ID: 20050619112559.C8F73F0B04@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1721
Logged by:          Chii-Tung Liu
Email address:      cdliou(at)mail(dot)cyut(dot)edu(dot)tw
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

Responses

pgsql-bugs by date

Next:From: Zhenlei CaiDate: 2005-06-19 12:16:10
Subject: B-tree unique index duplicate key error happens only in SUSE 9.3
Previous:From: Tino WildenhainDate: 2005-06-18 15:27:28
Subject: Re: process crash when a plpython function returns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group