Thread: 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.

Why are you still using 8.2 ?
Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



On Fri, Apr 6, 2012 at 5:05 PM, dmp <danap@ttc-cmc.net> wrote:
> 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.
>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc