[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