[FWTools] (no subject)

David Potts dave.potts at pinan.co.uk
Tue Oct 21 01:56:21 EDT 2008



Can the Fwtool toolkit deal with international character sets other than
standard ascii ?

 ogr2ogr -f   PostgreSQL PG:"host=127.0.0.1 user=dave dbname=foobar
port=5434" -nln foobar -append  itant-tpPoints.shp
Warning 1: Unable to detect single-column primary key for 'foobar'. Use
default 'ogc_fid'
Warning 1: Unable to detect single-column primary key for 'foobar'. Use
default 'ogc_fid'
ERROR 1: INSERT command for new feature failed.
ERROR:  invalid byte sequence for encoding "UTF8": 0x91
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 "foobar" (wkb_geometry , "grid_squar", "label",
"mapnum", "objectid", "symbol", "tpid") VALUES
(GeomFromEWKT('SRID=32767;POINT (-2.114480000000185
47.614519999999175)'::TEXT) , 'C1', '�Duretie�?', '14', 4,
'station, known', 690)
ERROR 1: Terminating translation prematurely after failed

I would normaly use something like

shp2pgsql -c -W iso-8859-1

with the normal postgres tools.  I would prefer to use ogr commands
because the handel .prj files.

Any suggestions

D.

-- 
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of the
Pinan Software





More information about the FWTools mailing list