[postgis-users] shp2pgsql character set conversions

[Stephen Woodbridge]

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.

I haven't tried this yet, (I will), but was wondering if there is any 
reason this would not work - like maybe it does not use iconv but 
another library like libicu.

Also if this works, we should add this information to the shp2pgsql 
documentation and only help.

Actually, now that I think about this, this will not work because -E 
UTF8 would go in the fromcode and the database encoding would go into 
the tocode. So we would need a commandline argument that would support 
adding the //IGNORE

Thoughts?

-Steve