[postgis-users] change the encoding for existing table

[Robert Buckley]

Hi,

I am testing the SpatialKit extention for ArcGIS which uploads data into Postgresql. When uploading into the database there is not an option to specify encoding types. Usually I choose "latin1" over "UTF-8" because latin1 enables the use of german characters (ä,ö,ü andß) .... although i have never understood why I should this instead of UTF-8 which apparently also contains these characters.

Anyway...The tables created by the SpatialKit extention seem to cause a problem with these characters. In order to test if the problem really is to do with the encoding, I would like to change it to latin1.

How can I do this in postgresql on a postgis table?

cheers,

Rob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120404/7689b55d/attachment.html>