problems with encoding - Mailing list pgsql-general

From Karina Guardado
Subject problems with encoding
Date
Msg-id 4a92b0c30910070244w33fcb5e7v5970077ae05a3c58@mail.gmail.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: "Jamie Lawrence-Jenner"
Date:
Subject: SSIS and Postgres
Next
From: "Loic d'Anterroches"
Date:
Subject: pg_dump with 1100 schemas being a bit slow