Re: [BUGS] BUG #1367: Unique constraint fails with some values

2004-12-31 Thread Magnus Hagander
>Bug reference: 1367 >Logged by: Hong Yuan >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Windows XP Chinese Simplified >Description:Unique constraint fails with some values >Details: > >I found that the unique constraint fails sometimes

Re: [BUGS] BUG #1367: Unique constraint fails with some values

2004-12-30 Thread Tom Lane
"Hong Yuan" <[EMAIL PROTECTED]> writes: > I found that the unique constraint fails sometimes when the varchar column > contain some specific Chinese characters. Here is an example: The usual cause of this sort of thing is that you've selected a database encoding that is not compatible with the loc