Postgresql with JDBC - Client encoding issue

[preethi.raj]

Hi,


In my project, we are using PostgreSQL jdbc driver for inserting data into db.
The values may contain other languages like Chinese, Japanese, German expressions.

Apart from inserting the English expression, am getting the following exceptions:

2012-10-11 02:41:37,589 [HttpClient-15] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 22P05
2012-10-11 02:41:37,589 [HttpClient-15] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 4 insert into summary (value, id, property) values ('Microsoft Windows 7 ??? ', '7', 'Name') was aborted. Call getNextException to see the cause.
2012-10-11 02:41:37,589 [HttpClient-15] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 22P05
2012-10-11 02:41:37,589 [HttpClient-15] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: character 0xe69797 of encoding "UTF8" has no equivalent in "WIN1252"

Please provide any suggestions

[Tolls]

Don't use WIN1252 character encoding on your database?
At least if I've interpreted that log output correctly.

[preethi.raj]

Don't use WIN1252 character encoding on your database?
At least if I've interpreted that log output correctly.

Thank you for your reply.
If i use the same insert query in PgAdmin tool , values are successfully inserted.
Through PostgreSQL JDBC driver only we are facing problems.

It seems the client_encode will be always set to Unicode in jdbc while start up.
Ref :
How to insert Chinese (big5) through JDBC? - Grokbase

After converting the Chinese string to Unicode in our program, we can able to insert through jdbc.
Is this the only option? Can we set the client_encode according to our need in jdbc?

Regards,
Preethi.

[Tolls]

With characters you need to ensure you are using the same character set throughout.
Well, either that or attempt to convert them which is not much fun.

The PgAdmin tool will be using whatever character set the db is set up for, so it's no great surprise that that works.

[preethi.raj]

Thanks for your solution.
After i changed the database encoding type to UTF8, we can able to insert any language string to database through JDBC.