Home > mailing lists

problem inserting local characters ... - Mailing list pgsql-sql

From	Garry
Subject	problem inserting local characters ...
Date	February 22, 2005 16:02:11
Msg-id	421B2D3E.5040205@gmx.de Whole thread Raw
Responses	Re: problem inserting local characters ... (Markus Schaber <schabios@logi-track.com>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: pginfo
Date: 22 February 2005, 15:43:53
Subject: Re: pg primary key bug?

From: Markus Schaber
Date: 22 February 2005, 16:37:03
Subject: Re: pg primary key bug?

problem inserting local characters ... - Mailing list pgsql-sql

Previous

Next