Maybe you could try to expressely set it to corresponding iso-8859-1 = LATIN1
(instead of latin1) or maybe IBM850. If you are on windows, you can just donwload previous version to try with older binaries. Cheers, Rémi-C 2014-02-07 Michael Fricker <michael.fric...@altusgroup.com>: > Hello. I’ve run into a problem with shp2pgsql, at the command > prompt, where the –W option to change the default character encoding of > UTF-8 to, for example LATIN1, is not working. If I’m correct, the –W > character encoding option should allow you to switch from the default UTF-8 > to any other character encode that is required. In my case it is LATIN1. I > used the following line below to store the .sql file. > > > > shp2pgsql.exe -d -s 2956:3401 -I -W "LATIN1" > "C:\0\Canada_Land_Survey_Data\test\Deliverables\CLSR_Land_Parcel.shp" > scratch.ab_clsr_land_parcel > > C:\0\Canada_Land_Survey_Data\Data_Dump\Land_Parcel_Error.sql > > > > A portion of the result is shown below. > > > > SET CLIENT_ENCODING TO UTF8; > > SET STANDARD_CONFORMING_STRINGS TO ON; > > SELECT DropGeometryColumn('scratch','ab_clsr_land_parcel','geom'); > > DROP TABLE "scratch"."ab_clsr_land_parcel"; > > BEGIN; > > CREATE TABLE "scratch"."ab_clsr_land_parcel" (gid serial, > > "pin" float8, > > "designator" varchar(254), > > "remain_ind" varchar(254), > > "planno" varchar(30), > > "admin_code" varchar(20), > > "pcl_type" varchar(254), > > "lcselectio" varchar(100), > > "remarks" varchar(254), > > "pcl_state" varchar(254), > > "reg_pin" varchar(254)); > > ALTER TABLE "scratch"."ab_clsr_land_parcel" ADD PRIMARY KEY (gid); > > SELECT AddGeometryColumn( > 'scratch','ab_clsr_land_parcel','geom','3401','MULTIPOLYGON',2); > > > > I would have expected the first line to have read SET CLIENT_ENCODING > TOLATIN1 instead of > SET CLIENT_ENCODING TO UTF8. > > > > Initially I was attempting to upload a shapefile to a database at work > using this command; > > > > shp2pgsql.exe -d -s 2956:3401 -I -W "LATIN1" > "C:\0\Canada_Land_Survey_Data\test\Deliverables\CLSR_Land_Parcel.shp" > scratch.ab_clsr_land_parcel | psql.exe -h "localhost" -p "5432" -U > "postgres" -d "major_testing_db" > > > > Instead of being uploaded, the resulting error occurred: > > > > ERROR: unterminated quoted string at or near “’” > > LINE 1: …o”,”remarks”,”pcl_state”,”reg_pin”,geom> VALUES <’1115077’,’ > > > ^ > > Reading through the .sql file, I tracked down the problem to be a > character not supported by UTF-8 in the following line (the small arrow > highlighted in red); > > > > INSERT INTO "scratch"."ab_clsr_land_parcel" > ("pin","designator","remain_ind","planno","admin_code","pcl_type","lcselectio","remarks","pcl_state","reg_pin",geom) > VALUES ('1115077','EJERE K’ELNI KUE INDIAN RESERVE 196I','No','84988 CLSR > AB','09888','Inside Canada Lands',NULL,NULL,'ACTIVE',NULL,ST_Transform(' > 01060000208C0B00……. > > > > When I used the shp2pgsql-gui and selected LATIN1 for the character > encoding, the shapefile was uploaded to the database without incident. Any > help and/or explanation would be appreciated. The version of both shp2pgsql > and shp2pgsql-gui that I have used is 2.1.0. Thanks to anyone for their > help. > > > > > > *Michael Fricker* > GIS Technician > Altus Geomatics > Limited Partnership > > T: 403.234.7599 ext 2395 > F: 403.261.4712 > > 840 7th Avenue SW, Suite 900 > Calgary, Alberta T2P 3G2 Canada > > *This message, and the documents attached hereto, are intended only for > the addressee and may contain privileged or confidential information. Any > unauthorized disclosure is strictly prohibited. If you have received this > message in error, please notify us immediately so that we may correct our > internal records. Please then delete the original message. Thank you.* > > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users