problem inserting local characters ...

From: Garry <gkg(at)gmx(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: problem inserting local characters ...
Date: 2005-02-22 13:01:50
Message-ID: 421B2D3E.5040205@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)email(dot)de',NULL,NULL,
'SMS-Pager','2(dot)email(at)email(dot)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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2005-02-22 13:36:16 Re: pg primary key bug?
Previous Message Ragnar Hafstað 2005-02-22 11:52:42 Re: pg primary key bug?