I am having difficulties when I try to load a shapefile into my database, the is because I do not know the encoding of the dbf portion of the shapefile. The attribute tables are in Spanish, I have tried UTF8 and LATIN1/ISO-8859-1.

How can I check the encoding of the dbf file? I do not want to waste anymore time trying all the encodings.

The database is Postgres 9.4.4 with Postgis 2.2.1, I use Qgis 2.10.1 to visualize the data before loading it to the database.

Looks like the files were made in a mac, not sure though.


When having enconding issues with a Shapefile you can try the QGIS Plugin Shapefile Encoding Fixer.

Other helpful questions are:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.