[postgis-devel] [PostGIS] #889: shp2pgsql fail load localized character

PostGIS trac at osgeo.org
Sun Mar 27 03:19:19 PDT 2011


#889: shp2pgsql fail load localized character
------------------------+---------------------------------------------------
 Reporter:  aperi2007   |       Owner:               
     Type:  defect      |      Status:  new          
 Priority:  high        |   Milestone:  PostGIS 2.0.0
Component:  management  |     Version:  trunk        
 Keywords:              |  
------------------------+---------------------------------------------------

Comment(by aperi2007):

 hi strk,
 using Latin1 it work !

 But I guess there is something other problem .

 Because
 effectively using the "Latin1" the original shapefile is loaded.
 But I notice another strange phenomenon.

 I have try to convert the line.shp to UTF8 version (using qgis)
 call it "line_utf8.shp" (add it to this ticket).

 I notice that using
 encoding "UTF8"
 shp2pgsql load only the "line_utf8.shp" and dont load the "line.shp"
 reporting no error.
 I guess an error would be reported. The sql file generate from shp2pgsql
 is simply stop to the first line of COPY.

 The second question is:
 Is right that shp2pgsql skip the load of a shapefile if encoding is set to
 UTF8 and the shapefile use a different encoding.
 Instead if the encoding is set to Latin1 it seem to be always loaded.
 Latin1 seem to be a special encoding setting.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/889#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.


More information about the postgis-devel mailing list