Hi Bob, Can you try to add the option -W "latin1" ? (the -W needs to be uppercase) This will take care of the encoding. Probably the default encoding is different from the one in the shapefile (which is always latin1).
HTH, Frank Citeren Robert Shand <[email protected]>: > 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 > > > _______________________________________________ > Talk-ca mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/talk-ca > _______________________________________________ Talk-ca mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk-ca
