Unexpected mismatch of client_encoding and server _encoding

Products

• VMware Tanzu Greenplum

Issue/Introduction

When using the GPDB provided JDBC driver to connect to GPDB, the script may return the following error:

unexpected mismatch of client_encoding and server _encoding

However, using the postgresql JDBC driver is successful.

This is due to the fact that the server encoding and client encoding do not match (case sensitive).

Server encoding:  UTF8
Client encoding: utf8

Environment

Product Version: 5.28

Resolution

From Datadirect (Postgres)'s website, the KB ODBC/JDBC connection to the database is case sensitive in regards to database name states that this is expected:
 

"Cause
This is expected behavior. Starting in OpenEdge 10.1C, SQL-92 connections to the database are case sensitive."