[postgis-users] change the encoding for existing table
robertdbuckley at yahoo.com
Wed Apr 4 05:10:28 PDT 2012
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?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users