[postgis-users] Encoding issue in PostGIS/PostgreSQL

Paul Ramsey pramsey at cleverelephant.ca
Sat Jan 10 15:21:47 PST 2009

Isn't this an encoding issue with PgAdmin? shp2pgsql writes out a UTF8  
text file. If you load that UTF8 text file into PgAdmin, and it thinks  
(hypothetically) that all text files is loads are in your local  
encoding, then the result in the window will have some "garbage  


On Jan 10, 2009, at 7:49 AM, Lê Viết Thanh wrote:

> Hi folks,
> i have some things made me quite confusedly  in characters encoding  
> of postgis/postgresql.
> Everything works fine If i use shp2pgsql to dump shapefiles to sql  
> file and then dump to postgis database in psql command, all  
> characters in shapefile are displayed correctly in postgis. However,  
> if i use pgAdmin III to load sql file that exported from shp2pgsql  
> command, the pgAdmin III show up incorrectly character encoding.
> Could anybody clarify this issue for me? I dont understand indeed  
> what happened
> Thanks in advance.
> -- 
> Thanh
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Paul Ramsey
pramsey at cleverelephant.ca
+1 250 885 0632

More information about the postgis-users mailing list