Re: LATIN2 'bssz' and 'bszsz' fails on unique index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sün <sun(at)true(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: LATIN2 'bssz' and 'bszsz' fails on unique index
Date: 2004-05-21 06:34:21
Message-ID: 24642.1085121261@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?ISO-8859-2?Q?S=FCn?= <sun(at)true(dot)hu> writes:
> If you use Latin2 encoding, you can not have 'bssz' and 'bszsz' in an
> unique column in the same time.

AFAICS this means that your locale definition considers these strings
equal.

It is possible that the real problem comes from using an encoding that's
not compatible with what the locale setting expects. Locales generally
do require a specific character set encoding, though this is poorly
documented :-(

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2004-05-21 10:42:13 Re: int4, int8, real ....division...
Previous Message Tom Lane 2004-05-20 18:10:59 Re: postgres crashes