Re: JDBC DatabaseMetaData problem

BCH)姜亦敏 wrote:
> Hello,
> I have the following problem working with DatabaseMetaData. There is a
> database with table and the attribute of 'cont' is character. Database
> cluster was
> initialized with appropriate ru_RU.KOI8-R locale. All the databases were
> created with utf-8 encoding.
> I use PostgreSQL-8.2compiled from source, JDBC driver from
> on Linux, J2SDK 1.4.2_12.
> update scheduleconttbl set cont ='\xf0\x9f\x99\x8f'
> where logindaytime = '20120406142138813';
> ~
> ~
> ~
> I will appreciate any help with this.
>
> Thank you.
>
>
> Sincerely yours,
> Jiang

Hello,

I just tried this same update on a table with char type with the input
indicated and it works fine on PostgreSQL 9.0.1 with jdbc-9.0-901.jdbc3.

Perhaps you need to update to a newer version of the database if you are
used the recommended supported version and correlated jdbc has indicated
at http://jdbc.postgresql.org/download.html

Version 8.2 Build 512 and JDBC2 8.2-512 JDBC2 which I think supports
JRE 1.4.

danap.