<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi, everyone,<div><br></div><div><span class="Apple-style-span" style="font-family: 'Lucida Grande'; ">I think that I can describe this as a very, very stupid encoding question. I'm getting an error in shp2pgsql about changing the encoding of the database, and when I try changing via the \encoding function, I find that the changes are not sticking. Is there a better way to do this?</span></div><div><span class="Apple-style-span" style="font-family: 'Lucida Grande'; "><br></span></div><div><span class="Apple-style-span" style="font-family: 'Lucida Grande'; "><div>tardis-2:County Shapefile dheerajchand$ shp2pgsql -s 4326 tl_2009_us_county public.counties | psql -U dheerajchand -h localhost -p 5432 -d jamaa</div><div>Shapefile type: Polygon</div><div>Postgis type: MULTIPOLYGON[2]</div><div>SET</div><div>SET</div><div>BEGIN</div><div>NOTICE: CREATE TABLE will create implicit sequence "counties_gid_seq" for serial column "counties.gid"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "counties_pkey" for table "counties"</div><div>CREATE TABLE</div><div> addgeometrycolumn </div><div>--------------------------------------------------------------</div><div> public.counties.the_geom SRID:4326 TYPE:MULTIPOLYGON DIMS:2 </div><div>(1 row)</div><div><br></div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>INSERT 0 1</div><div>Unable to convert data value to UTF-8 (iconv reports "Illegal byte sequence"). Current encoding is "UTF-8". Try "LATIN1" (Western European), or one of the values described at <a href="http://www.postgresql.org/docs/current/static/multibyte.html">http://www.postgresql.org/docs/current/static/multibyte.html</a>.</div><div>INSERT 0 1</div><div>tardis-2:County Shapefile dheerajchand$ </div><div><br></div></span></div></body></html>