Re: BUG #1046: UNIQUE INDEX BUG

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: abaqueirob(at)hotmail(dot)com
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1046: UNIQUE INDEX BUG
Date: 2004-01-10 16:53:39
Message-ID: 9853.1073753619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> then when inserting values it says = = = =
> (confuses different acuted vowels as if they were the same thing)

Sounds to me like you have selected the wrong character set (encoding)
or wrong locale when installing the database. If Postgres thinks those
strings are equal, it is because the strcoll() library routine says so.
You need to pick a locale that will behave the way you want.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Allan Tong 2004-01-10 18:58:17 data loss after vacuum
Previous Message PostgreSQL Bugs List 2004-01-10 10:23:38 BUG #1047: sdav