[Talk-ca] Errors importing NRN shapefiles

[steggink at steggink.org]

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 <bob at shand.org.uk>:

> 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
> Talk-ca at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-ca
>