[postgis-devel] [PostGIS] #808: shp2pgsql and encoding, something must be wrong

[PostGIS]

#808: shp2pgsql and encoding, something must be wrong
---------------------+------------------------------------------------------
 Reporter:  nicklas  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Nicklas,

 I'll give this one a try.  My understanding was that shp2pgsql looks at
 the encoding and translates the encoding from what was specified LATIN1 to
 UTF8 so that by the time it gets to the .sql export it is already in
 UTF-8.  That is why you don't see anything different in the sql file
 (except that the text should have been rewritten as UTF8).  I could be
 wrong though.

 Anyrate that is my understanding why we compile shp2pgsql with iconv
 support so it can do that translation.   I never did quite understand why
 we don't just have PostgreSQL do the translation (or rather I forgot why)
 except its less portable (e.g. I think WIN1252 is valid on windows and not
 on unix (or at least not PostgreSQL linux)

 Have you tried the 1.5 version to see if this is just an issue in trunk?
 So much stuff has changed in trunk.

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