I'm trying to import ArcGIS shapefile to PostGIS. I get an error like this:
My client and server encoding both of them "UTF-8"
I get an error especially in the point type.
How can I fix it?
I tried Latin1 and Latin3 but did not work.
I think your issue is that your shapefile's DBF character encoding is not UTF-8. By default shp2pgsql-gui assumes the incoming encoding is UTF-8 so if there is a mismatch here the tool will fail.
You need to ensure that the DBF file character encoding (accessed through the Options menu of shp2pgsql-gui) matches that of your shapefile.
If you don't know what the DBF encoding is and UTF-8 hasn't worked, it's worth trying LATIN-1.