[postgis-users] load shapefiles in GB2312

Steffen Macke sdteffen at gmail.com
Wed Feb 22 04:04:20 PST 2006


> For a shapefile in GB2312 encoding, what is the
> correct way to load it into postgis db using
> shp2pgsql?

You can try the following (Windows):

set PGCLIENTENCODING=GB2312
shp2pgsql test roads > roads.sql
psql -f roads.sql database

For other operating systems, you may have to adjust the
way to set the environment variable.

Steffen



More information about the postgis-users mailing list