X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AB95E8B9B19 for ; Tue, 22 Feb 2005 13:02:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52327-04 for ; Tue, 22 Feb 2005 13:01:47 +0000 (GMT) Received: from mx-ha02.regio.net (mx-ha02.regionetworks.de [212.218.64.57]) by svr1.postgresql.org (Postfix) with ESMTP id 556CD8B9B16 for ; Tue, 22 Feb 2005 13:01:49 +0000 (GMT) Received: from [195.158.42.110] ([195.158.42.110]) by mx-ha02.regio.net (8.12.11/8.12.10/SuSE Linux 0.7) with ESMTP id j1MD1vZI016611; Tue, 22 Feb 2005 14:01:57 +0100 Message-ID: <421B2D3E.5040205@gmx.de> Date: Tue, 22 Feb 2005 14:01:50 +0100 From: Garry User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: problem inserting local characters ... Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/238 X-Sequence-Number: 20349 Hi, I'm running PostGreSql 7.4.6 on SuSE 9.1. Everything as such is working fine. In order to import some data from an old system, I create an SQL script that does something like: insert into prg_contacts values ('2005-02-22 13:45:36+01','NETHINKS Converter',NULL,NULL,'admin','s', NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL, NULL,'Anrede','Titel','Vorname', NULL,'Firmenname','TelefonGeschäft','Faxnr', 'TelefonMobil','email@email.de',NULL,NULL, 'SMS-Pager','2.email@email.de','Firmenland','FirmenOrt', 'FirmenPLZ',NULL,'Firmenbundesland','Firmenstraße', NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL, [..] Trying to do this insert, I get an error on both the values "TelefonGeschäft" and "Firmenstraße": FEHLER: ungültige Byte-Sequenz für Kodierung »UNICODE«: 0xe165 (the 0xe165 differs between the two; the fields in question are regular type "text" fields) Looks like I'm having some trouble with unicode encoding ... The characters I have are regular 8bit ASCII chars ... How can I fix this? Help appreciated, -gg