[postgis-users] shp2pgsql UTF-8 Encoding Problem

Paul Ramsey pramsey at refractions.net
Mon Feb 19 13:14:39 PST 2007


The list of encodings is here:

http://www.postgresql.org/docs/8.1/static/multibyte.html

What you want to provide in -W is not the database encoding (that's 
already known) but rather the encoding of the strings in your DBF file. 
If it's a European language, probably the encoding you want is LATIN1.

Paul

paallen at attglobal.net wrote:
> Hi all,
> 
> I am using Windows XP SP2 (USA English),
> PostgreSQL 8.2 and PostGIS 1.2.0-1 
> 
> I have a database with UTF-8 encoding and I am
> trying to import a multipolygon shape file with
> shp2pgsql and it keeps giving me an encoding error
> upon loading it into the database.  I know this is
> due to the UNICODE and I found some listings about
> this from 2005 but my encoding skills are weak.
> 
> I have used the shp2pgsql with -w and no better
> luck.  I have changed the code page first with
> “chcp 1252” and still no luck.  Whenever I use the
> “-W UTF-8” it bombs out because “UTF-8” is not a
> recognized code.  
> 
> What are the window's users procedures to import
> an plan-jane US ASCII shape file into an UTF-8
> database.  I am interested in passing this stage
> so I can experiment with the latest ZigGIS release!
> 
> Thanks a lot.
> 
> Phillip J. Allen
> Consulting Geochemist
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632



More information about the postgis-users mailing list