> 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