[postgis-users] shp2pgsql character set conversions

Sandro Santilli strk at keybit.net
Sat Mar 12 00:21:56 PST 2011

On Sat, Mar 12, 2011 at 12:57:50AM -0500, Stephen Woodbridge wrote:
> Hi All,
> I am trying to load a shpfile that is in UTF8, but there is some random 
> character that is not. This is causing a load error and rollback on the 
> transaction.
> I notice looking at:
> man 2 iconv_open
> that it is possible to add //IGNORE and/or //TRANSLIT to the tocode string.

Someone submitted a patch some time ago supporting this.
Generally, I think it'd be good to have a switch to set a policy
on encoding errors, like we have on NULL geometries handling (-N).


  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

More information about the postgis-users mailing list