Re: SET client_encoding = 'UTF8'

[Oliver Jowett <oliver(at)opencloud(dot)com>]

Tom Lane wrote:
> Daniel Migowski <dmigowski(at)ikoffice(dot)de> writes:
> > The command
> >     SET client_encoding = 'UTF8'
> > throws an exception in the driver, because the driver expects UNICODE.
>
> Er, what driver exactly?  Perhaps you need a more up-to-date version
> of said driver?  'UTF8' has been our standard spelling of this
> encoding's name for quite some time now.

The driver requests client_encoding = UNICODE in the startup packet, and 
expects client_encoding to stay as UNICODE throughout.

If client code goes off and manually sets it to UTF8 then the JDBC 
driver complains, because it doesn't know that UNICODE is equivalent to 
UTF8.

-O