X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9D9FF9DC81E for ; Tue, 13 Dec 2005 17:10:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22797-10 for ; Tue, 13 Dec 2005 17:10:20 -0400 (AST) X-Greylist: delayed 00:06:40.263693 by SQLgrey- Received: from p15103086.pureserver.info (ccmonitor.de [217.160.129.148]) by postgresql.org (Postfix) with ESMTP id C11C39DC850 for ; Tue, 13 Dec 2005 17:10:16 -0400 (AST) Received: (qmail 23665 invoked from network); 13 Dec 2005 22:03:36 +0100 Received: from h53n2c1o1110.bredband.skanova.com (HELO ?192.168.1.3?) (81.235.40.53) by ccmonitor.de with (DHE-RSA-AES256-SHA encrypted) SMTP; 13 Dec 2005 22:03:36 +0100 Message-ID: <439F371E.6030706@publisher.de> Date: Tue, 13 Dec 2005 22:03:26 +0100 From: Ulrich Wisser User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: encoding error Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/113 X-Sequence-Number: 19833 Hello, I try to insert some japanese text in my database. But it fails with=20 duplicate value error, although I use two different values. My database=20 is set up with UNICODE, I even tried a SQL_ASCII set up where I do all=20 conversion manual, but nothing worked, the error persists. Please find=20 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=20 ('=C3=A3\202=C2=AD=C3=A3\203=C2=A3=C3=A3\203=C2=A9=C3=A3\203=C2=A1=C3=A3\= 203=C2=AB=C3=A3\202\222=C3=A8=C2=B3=C2=BC=C3=A5\205=C2=A5=C3=A3\201\231=C3= =A3\202\213'); insert into kw (keyword) values=20 ('=C3=A3\202=C2=AC=C3=A3\203\212=C3=A3\203\203=C3=A3\202=C2=B7=C3=A3\203=C2= =A5=C3=A3\202\222=C3=A8=C2=B3=C2=BC=C3=A5\205=C2=A5=C3=A3\201\231=C3=A3\2= 02\213'); ERROR: duplicate key violates unique constraint "kw_pkey"