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
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 |