[postgis-users] Encoding issue in PostGIS/PostgreSQL

Lê Viết Thanh lethanhx2k at gmail.com
Thu Jan 15 00:41:54 PST 2009


Thanks Paul

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".
>
> 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
> --
> Paul Ramsey
> pramsey at cleverelephant.ca
> +1 250 885 0632
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Thanh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090115/b7d3f5e2/attachment.html>


More information about the postgis-users mailing list