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 ?
Thanks
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 ?
Thanks
jhl
0 Answers:
No answers yet
