X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C231C9FA5BA for ; Thu, 15 Jun 2006 08:02:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82975-01 for ; Thu, 15 Jun 2006 08:02:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.21]) by postgresql.org (Postfix) with SMTP id 7B9089F9AD3 for ; Thu, 15 Jun 2006 08:02:00 -0300 (ADT) Received: (qmail invoked by alias); 15 Jun 2006 11:01:58 -0000 Received: from dslb-084-057-021-234.pools.arcor-ip.net (EHLO ltmku) [84.57.21.234] by mail.gmx.net (mp023) with SMTP; 15 Jun 2006 13:01:58 +0200 X-Authenticated: #23352258 From: "Milen Kulev" To: Subject: UTF-8 Problem ? Date: Thu, 15 Jun 2006 13:01:56 +0200 Message-ID: <016d01c6906b$1e5c6570$0a00a8c0@trivadis.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/172 X-Sequence-Number: 25408 Hi Listers, I want to insert some german specific characters (umlaut characters) = into a table, but I am getting the following=20 Error message: postgres=3D# EXECUTE stmt (1, 1 , 1 , 'Gr=FCn') ; ERROR: invalid UTF-8 byte sequence detected near byte 0xfc Or=20 postgres=3D# EXECUTE stmt (1, 1 , 1 , 'MA=DF=DFtab') ; ERROR: invalid UTF-8 byte sequence detected near byte 0xdf Here are my object/statement definitions : A) PREPARE stmt( int, int, int, varchar) as insert INTO part values = ($1,$2,$3,$4); B)=20 postgres=3D# \d+ part Table "public.part" Column | Type | Modifiers | Description --------+------------------------+-----------+------------- id1 | integer | not null | id2 | integer | not null | id3 | integer | not null | filler | character varying(200) | | C)=20 postgres=3D# l\l List of databases Name | Owner | Encoding ------------+-------+----------- db1 | user1 | SQL_ASCII postgres | pg | UTF8 template0 | pg | UTF8 template1 | pg | UTF8 How to solve my problem ?=20 Best Regards. Milen=20