French character / mySql

By: jhl - jhl
French character / mySql
2003-01-15 08:43
Hi Teodor,

I'm having trouble to retreive french characters from database in the generation of view/report.
The problem does not occur if text is static.
it occurs only when filling report with fields values from mySql database.
mySql is configured with iso-8859-1 encoding.
JDBC is configured with iso-8859-1 encoding.

a "System.out.println" just before fos.write in the exportReportToFile is Ok. characters are OK.
But, the html file contains only "?" character instead of "馱uot;. same result in the viewer.

a "objValue = new String(resultSet.getBytes(field.getName()),"iso-8859-1" );" in getFieldValue of JRResultSetDataSource for String class do not solve it.

I've already read mails in the forum with this character/database problem but with no correct answer ...

Any idea ?

2002 JI Open Discussion's picture
Joined: Aug 10 2006 - 3:28am
Last seen: 17 years 1 month ago

0 Answers:

No answers yet