Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
i have a problem with importing my shapefile to postgreSQL, it's a poroblem with the encoding, here's the screenshot:
i tried to change encodingin "options" buti get this message:
"Failed in pgui_exec(): ERREUR: séquence d'octets invalide pour l'encodage « UTF8 » : 0xe3 0xa9 0x72
Shapefile import failed. "
Do i have to change the encoding in arcgis?and how?
thnks in advance
Before you start importing in the Shapefile-loader click on the "options"-button and there replace "UTF8" with the correct encoding.
Based on the answer to Which character encoding is used by the DBF file in shapefiles?:
To change the encoding of a DBF open it with OpenOffice Calc.. choose SaveAs... click the "Filter options" in the bottom left and press save. You can then define the encoding to convert the text contents into.
As you may already know, feature attributes of your Shapefiles are stored in a DBF file. Go to the folder where the Shapefile is located and you see the DBF file. You can get OpenOffice Calc (or better yet, LibreOffice Calc from here).
Concerning field names of your Shapefile, from the same answer:
Attention: All this only applies to the data, not the column names. You should really only use ASCII in the column names of a DBF if you want the file to be openable with other programs.
