From: Garry <gkg@gmx.de>
To: pgsql-sql@postgresql.org
Subject: problem inserting local characters ...
Date: Tue, 22 Feb 2005 14:01:50 +0100
Message-ID: <421B2D3E.5040205@gmx.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gkg@gmx.de
Subject: Re: problem inserting local characters ...
In-Reply-To: <421B2D3E.5040205@gmx.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox