Jitterbit · Database connector (PostgreSQL ODBC)

PostgreSQL: client encoding mismatch

Short answer

This Jitterbit PostgreSQL error means the encoding the server uses differs from the default encoding the PostgreSQL ODBC driver assumes. In the Database connection settings, add ConnSettings=SET CLIENT_ENCODING to 'LATIN1' to Additional Connection String Parameters, substituting the server's encoding.

VerifiedLast verified

01Error text

Jitterbit error
client encoding mismatch

02Likely causes

  • The encoding the PostgreSQL server uses differs from the default encoding the PostgreSQL ODBC driver assumes.

03How to fix it

  1. In the Database connection settings, add ConnSettings=SET CLIENT_ENCODING to 'LATIN1' to Additional Connection String Parameters, substituting the server's encoding.
  2. On Windows, if the server uses a Cyrillic encoding such as WIN1251, also set the client encoding to WIN1251 in the ODBC driver settings.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.