Thanks Richard
That imported the blocks and text as far as viewing is concerned.
However, the text is part of the Linestring layer and not in the text column
of the Postgresql table.
Is this to be expected?
Is there some way of identifying the text?
Bob
-----Original Message-----
From: Richard Greenwood
Sent: Wednesday, December 14, 2011 8:52 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Encoding problem UTF-8
Bob,
Before running ogr2ogr try setting:
set PGCLIENTENCODING=LATIN1
Rich
On Wed, Dec 14, 2011 at 11:28 AM, Bob Pawley <[email protected]> wrote:
Hi
I am attempting to import a dxf file to Postgis using ogr2ogr version 1.8
running on Win 7.
I get errors “invalid byte sequence for encoding "UTF8": 0xfe” using the
following command in command prompt. Points and text are not being
imported.
set DXF_INLINE_BLOCKS=false&set DXF_MERGE_BLOCK_GEOMETRIES=false&&ogr2ogr
--config DXF_ENCODING UTF-8 -f "PostgreSQL" PG:"host=localhost
user=postgres
dbname=IDW password=calgary0623" Water_Ex.dxf -nln Import_PID -overwrite
-skipfailures
During research of this problem I came upon a suggestion to check with the
Postgre list.
Can anyone suggest a solution?
Following are a few of the error messages.
Bob
LIST', '{1,1,1}', 0) RETURNING ogc_fid
ERROR 1: INSERT command for new feature failed.
ERROR: invalid byte sequence for encoding "UTF8": 0xfe
Command: INSERT INTO "import_pid" ("wkb_geometry" , "layer", "subclasses",
"exte
ndedentity", "entityhandle", "blockname", "blockscale", "blockangle")
VALUES
(Ge
omFromEWKT('SRID=-1;POINT (0.003291735334244 -0.065895915915561)'::TEXT) ,
'MC-A
TT', 'AcDbEntity:AcDbBlockReference', ' 4 tag_rev1 t 1
KEYTAG■C,10,0 RE
V_ID■C,10,0 REVISION■C,3,0 REVISED_BY■C,10,0 REVISED_ON■C,14,0
REV_TITLE■C,32,0
REV_BY_APP■C,16,0 APPROVEDBY■C,10,0 PENDING■C,1,0 PEND_MAIL■C,10,0',
'327A',
'_A
T_DIRLIST', '{1,1,1}', 0) RETURNING ogc_fid
ERROR 1: INSERT command for new feature failed.
ERROR: invalid byte sequence for encoding "UTF8": 0xfe
Command: INSERT INTO "import_pid" ("wkb_geometry" , "layer", "subclasses",
"exte
ndedentity", "entityhandle", "blockname", "blockscale", "blockangle")
VALUES
(Ge
omFromEWKT('SRID=-1;POINT (0.003291735334244 -0.065895915915561)'::TEXT) ,
'MC-A
TT', 'AcDbEntity:AcDbBlockReference', ' 4 tag_rev2 t 1
REV_ID■C,10,0 RE
V_DETAIL■C,50,0 REV_INT■N,3,0', '327B', '_AT_DIRLIST', '{1,1,1}', 0)
RETURNING o
gc_fid
ERROR 1: INSERT command for new feature failed.
ERROR: invalid byte sequence for encoding "UTF8": 0xfe
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Richard Greenwood
[email protected]
www.greenwoodmap.com
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
