Thanks Paul On Sun, Jan 11, 2009 at 6:21 AM, Paul Ramsey <[email protected]>wrote:
> 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 > -- Thanh
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
