[postgis-users] Encoding issue in PostGIS/PostgreSQL
Lê Viết Thanh
lethanhx2k at gmail.com
Thu Jan 15 00:41:54 PST 2009
On Sun, Jan 11, 2009 at 6:21 AM, Paul Ramsey <pramsey at cleverelephant.ca>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".
> 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
>> 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
>> Thanks in advance.
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
> Paul Ramsey
> pramsey at cleverelephant.ca
> +1 250 885 0632
> postgis-users mailing list
> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users