encoding error

From: Ulrich Wisser <liste(at)publisher(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: encoding error
Date: 2005-12-13 21:03:26
Message-ID: 439F371E.6030706@publisher.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I try to insert some japanese text in my database. But it fails with
duplicate value error, although I use two different values. My database
is set up with UNICODE, I even tried a SQL_ASCII set up where I do all
conversion manual, but nothing worked, the error persists. Please find
the smallest possible example attached below.

I verified it in 7.4.7 and 8.1.

Any ideas welcome!

TIA

Ulrich

createdb test -E unicode

in psql:

create table kw(keyword varchar(256) primary key);

insert into kw (keyword) values
('ã\202­ã\203£ã\203©ã\203¡ã\203«ã\202\222è³¼å\205¥ã\201\231ã\202\213');
insert into kw (keyword) values
('ã\202¬ã\203\212ã\203\203ã\202·ã\203¥ã\202\222è³¼å\205¥ã\201\231ã\202\213');
ERROR: duplicate key violates unique constraint "kw_pkey"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-12-14 03:40:12 Re: encoding error
Previous Message Chris Hoover 2005-12-13 20:54:53 8.1.1 initdb problems