Your shapefile attributes have hibit characters in them. As the error message states, you might want to try a LATIN1 encoding (if your data are western european) or perhaps another more appropriate encoding (http://www.postgresql.org/docs/8.1/static/multibyte.html) if they are not.
P On Thu, Jan 6, 2011 at 3:42 PM, Dheeraj Chand <dhee...@dheerajchand.com> wrote: > Hello, all! > First post, and it's a repeat of a question I was asking in the IRC channel. > I'm having some trouble with shp2pgsql. I installed PostGIS 1.5.2 from > source, on PostgreSQL 9.0.2, from source, and I think that I must have done > something incorrectly, because when I try to load a shapefile into a > database created according to the PostGIS template, I get an encoding > error. I realise that the term output here is long, but would someone mind > taking a look at it and confirming that I did this > correctly? http://dheerajchand.pastebin.com/YaHt3kAp > Thanks, > > -dx > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users