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
characters".
P.
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
[email protected]
+1 250 885 0632
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
