Re: BUG #1046: UNIQUE INDEX BUG - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1046: UNIQUE INDEX BUG
Date
Msg-id 9853.1073753619@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1046: UNIQUE INDEX BUG  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1047: sdav
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1048: error connection to dbms from java app server