[postgis-users] identify rows in a shapefile that have illegal characters for UTF-8 encoding

[Mark Volz]

Hello,

I am trying to load my parcels into PostGIS, which will eventually be consumed by MapServer, and ArcGIS.  Initially when loaded my data I received a warning that I should change my encoding from UTF-8 to LATIN1.  Doing so allowed me to load data into PostGIS however, I could not consume the data in ArcGIS.  So from what I observed, I need to stick with UTF-8 encoding.  I have determined that the field for the legal description in my parcels is stopping me from loading the shapefile into PostGIS using UTF-8.

How can I find out which rows in my shapefile have illegal characters for UTF-8 encoding? 

Thank You


Mark Volz
GIS Specialist