JDBC driver, client_encoding and a SQL_ASCII database in production

Hello All,

I am using Pentaho Data Integration (PDI) to transform a database in
production to some other database, correctly structured for my business
intelligence analysis purpose.
PDI uses the JDBC driver to perform the transformation. The issue is
that JDBC only works with UTF-8 as client_encoding while the charset of
the database in production is SQL_ASCII and was filled with ISO-8859-1
characters (and is full of characters such as é è ô ...). The only way I
can get the correct string back is to use client_encoding='LATIN1'.

Changing the character set of the original database is not an option as
it is in production.

Anyone has a good idea on how could I proceed to get correctly the content ?

Regards,
 - Emmanuel

--
Ingénieur étude et développement
Intrinsec
215, avenue Georges Clemenceau
92000 Nanterre
http://www.intrinsec.com





Emmanuel GUITON

Ingénieur développement
Standard : +33 1 41 91 77 77 l Fax : +33 1 41 91 77 78

215, avenue Georges Clemenceau l 92024 NANTERRE
http://www.intrinsec.com/img_site/content/20091216V2_Intrinsec_diversite.pdf
http://www.intrinsec.com/