| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Daniel Migowski <dmigowski(at)ikoffice(dot)de>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: SET client_encoding = 'UTF8' |
| Date: | 2008-05-18 08:37:25 |
| Message-ID: | 482FEAC5.7010904@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Migowski | 2008-05-19 08:18:01 | Re: SET client_encoding = 'UTF8' |
| Previous Message | Tom Lane | 2008-05-18 05:10:57 | Re: SET client_encoding = 'UTF8' |