Re: BUG #1367: Unique constraint fails with some values

>Bug reference:      1367
>Logged by:          Hong Yuan
>Email address:      hongyuan@homemaster.cn
>PostgreSQL version: 8.0
>Operating system:   Windows XP Chinese Simplified
>Description:        Unique constraint fails with some values
>Details:=20
>
>I found that the unique constraint fails sometimes when the=20
>varchar column
>contain some specific Chinese characters. Here is an example:
>
>CREATE TABLE test
>(
>  col1 varchar(10),
>  CONSTRAINT col1 UNIQUE (col1)
>)=20
>WITHOUT OIDS;
>
>insert into test values('=E5=A4=A7');
>insert into test values('=E5=A4=A7');
>insert into test values('=E5=A4=A7');
>
>While the second and third inserts should fail, they do not.=20
>With some other
>Chinese characters, the constraint is observed.
>
>The character '=E5=A4=A7' has utf-8 encoding '\xe5\xa4\xa7'.
>
>The database is created with UNICODE encoding. The problem is=20
>present with
>version 8.0.0-rc2.


UNICODE encoding is not properly supported on Win32 at this time.=20

//Magnus