I tried to import a shapefile to postgresql. I used PostGIS shapefile import/export manager. Earlier I have done same thing but did not face any problem. But this time I am facing problem with encoding. First I tried to import into an exsisting database with UTF-8 encoding. It showed following error:
Shapefile type: Polygon PostGIS type: MULTIPOLYGON Unable to convert data value to UTF-8 (iconv reports "Invalid argument"). Current encoding is "UTF-8". Try "LATIN1" (Western European), or one of the values described at http://www.postgresql.org/docs/current/static/multibyte.html. Shapefile import failed.
So, I created another database with 'LATIN1' encoding with collation C and character type C. Then tried to set client encoding to 'LATIN1' by executing the following query.
Now tried to import. But still it is showing client encoding is UTF-8 and import fails. Screen shot is attached. What to do?