[Talk-ca] Errors importing NRN shapefiles
Robert Shand
bob at shand.org.uk
Sat Feb 27 23:45:19 GMT 2010
Hi Everyone,
I'm once again playing with NRN import now that I have more free time.
I noticed I'm getting some errors importing the shapefile into my gis database
shp2pgsql -s 4326 NRN_PE_8_0_ROADSEG nrn_roadseg | psql -d gis -f -
<snip>
psql:<stdin>:16493: ERROR: invalid byte sequence for encoding "UTF8": 0xe96527
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".
psql:<stdin>:16494: ERROR: current transaction is aborted, commands ignored until end of transaction block
etc. etc.
Does anyone know how I can fix this error - or will I have to live with that data not making it into my database.
Thanks
Bob
More information about the Talk-ca
mailing list