[postgis-tickets] [PostGIS] #3660: Cannot import shapefile due to encoding problem

[PostGIS]

#3660: Cannot import shapefile due to encoding problem
---------------------------+---------------------------
  Reporter:  miguelluaces  |      Owner:  strk
      Type:  defect        |     Status:  closed
  Priority:  blocker       |  Milestone:  PostGIS 2.3.1
 Component:  liblwgeom     |    Version:  2.3.x
Resolution:  invalid       |   Keywords:  shp2pgsql
---------------------------+---------------------------

Comment (by miguelluaces):

 I should have written explicitly that the dataset is UTF-8, not LATIN1. If
 you open the dbf file in LibreOffice using Latin1 as encoding you can see
 that row number 3 is shown as

 Muíño Daniel o Ferreiro

 instead of :

 Muíño Daniel o Ferreiro

 What should I do now? Compile it myself and set a breakpoint to see which
 is the offending character? I would rather have the error messages
 improved to show me which is the offending row so that I can try to fix
 it.

 And again, the same shapefile can be imported with shp2pgsql 2.1.7 with
 the same commandline without errors.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3660#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.