postgresqlcharacter-encodingpgloader

pgloader not able to load Spanish Language characters

pgloader is failing to load Spanish language characters sets in PostgreSQL. Are there any settings in PostgreSQL and/or pgloader that need to be enabled before trying to transfer the data?

Solution

  • A colleague demonstrated that setting the encoding to LATIN-1 instead of UTF-8 successfully allowed us to load the Spanish language data.