problems with encoding

From: Karina Guardado <kguardado(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: problems with encoding
Date: 2009-10-07 09:44:14
Message-ID: 4a92b0c30910070244w33fcb5e7v5970077ae05a3c58@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a Map info file named map.TAB and when I tried to export it to
Postgres I get an error of encoding so I used konwert to convert it to utf8
using the following statement
konwert any/es-utf8 map.TAB -O

But this only convert the name of the header of each column but not the
registers of each column so I don't know what to do in order to make it work
and I get the following error

ERROR 1: INSERT command for new feature failed.
ERROR: invalid byte sequence for encoding "UTF8": 0xe17465
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".

Command: INSERT INTO "geocalderas" (wkb_geometry , "fnode_", "tnode_",
"lpoly_", "rpoly_", "length", "geo_lin_", "geo_lin_id", "fnode1", "tnode1",
"lpoly1", "rpoly1", "geo_lin1", "geo_lin__1", "fnode1_1", "tnode1_1",
"lpoly1_1", "cod", "iden", "descripció") VALUES
(GeomFromEWKT('SRID=32767;LINESTRING (447585.611617154267151
352945.605798984819558,447663.959493021073285
352903.167054586228915,447669.807996430899948
352846.719404269650113,447645.862237187044229
352814.281670245632995,447594.825768752663862
352805.778938578849193,447551.734437025908846
352808.138727543642744)'::TEXT) , 291, 297, 0,
0, 281.033, 175, 83, 0, 0, 0,
0, 0, 0, 0, 0, 0, 600300,
12083, 'Cr�ter, caldera')
ERROR 1: Terminating translation prematurely after failed

any help please,

thanks

karina

Browse pgsql-general by date

  From Date Subject
Next Message Loic d'Anterroches 2009-10-07 10:51:06 pg_dump with 1100 schemas being a bit slow
Previous Message Jamie Lawrence-Jenner 2009-10-07 08:26:19 SSIS and Postgres