Unexpected mismatch of client_encoding and server_encoding

Products

• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

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

Cause

The server_encoding anf the client_encoding should be specified with the same case. Either both in uppercase or both in lowercase.

Resolution

This is expected behavior:
 

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