[postgis-users] shp2pgsql character set conversions

[Sandro Santilli]

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).

--strk;

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