[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