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

2005-06-19 Thread 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 U

[BUGS] B-tree unique index duplicate key error happens only in SUSE 9.3

2005-06-19 Thread Zhenlei Cai
This bug happens in SUSE 9.3 on both Pentium 4 and AMD64, whether the binaries are from postgresql-8.0.1 RPMs on the SUSE 9.3 DVD or are built from 8.0.3 source code. However this bug does NOT happen with a Debian box (unstable) running 8.0.3 on an x86 (Athlon XP, whether binary or built from sour

Re: [BUGS] B-tree unique index duplicate key error happens only in SUSE 9.3

2005-06-19 Thread John Hansen
FYI, Works just fine on gentoo with the UTF8 and ICU patches. ... John > This bug happens in SUSE 9.3 on both Pentium 4 and AMD64, > whether the binaries are from postgresql-8.0.1 RPMs on the > SUSE 9.3 DVD or are built from 8.0.3 source code. However > this bug does NOT happen with a Debian

Re: [BUGS] B-tree unique index duplicate key error happens only in SUSE 9.3

2005-06-19 Thread Tom Lane
Zhenlei Cai <[EMAIL PROTECTED]> writes: > This bug happens in SUSE 9.3 on both Pentium 4 and AMD64, whether the > binaries are from postgresql-8.0.1 RPMs on the SUSE 9.3 DVD or are > built from 8.0.3 source code. However this bug does NOT happen with a > Debian box (unstable) running 8.0.3 on an x

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

2005-06-19 Thread Tom Lane
"Chii-Tung Liu" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.0.3 > Operating system: Windows XP SP2 > When compare two UTF-8 encoded string that contains Chinese words, the > result is always TRUE Sorry, but UTF-8 encoding doesn't work properly on Windows (yet). Use some other database e

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

2005-06-19 Thread Kris Jurka
On Sun, 19 Jun 2005, Tom Lane wrote: > "Chii-Tung Liu" <[EMAIL PROTECTED]> writes: > > PostgreSQL version: 8.0.3 > > Operating system: Windows XP SP2 > > > When compare two UTF-8 encoded string that contains Chinese words, the > > result is always TRUE > > Sorry, but UTF-8 encoding doesn't w

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

2005-06-19 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > On Sun, 19 Jun 2005, Tom Lane wrote: >> Sorry, but UTF-8 encoding doesn't work properly on Windows (yet). >> Use some other database encoding. > Shouldn't we forbid its creation then? There was serious discussion of that before the 8.0 release, but we deci

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

2005-06-19 Thread Tatsuo Ishii
> 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: >