Problem with special characters from database

[2002 JI Open Discussion]

By: J O M Okomba - okomba

Problem with special characters from database

2003-10-23 01:52

 

I need to display '‰' (e.g. 2.2‰) in a report (pdf report) but jasperreport is ignoring the '‰' character (only displaying 2.2).

 

The '‰' displays correctly when I put manualy, i.e:

 

<textFieldExpression class="java.lang.String"><![CDATA["2.2‰"]]></textFieldExpression>

 

But doesn't display when I retrieve data from database, i.e.:

<textFieldExpression class="java.lang.String"><![CDATA[$F{data}]]></textFieldExpression>

 

I thought the problem was with the JDBC driver but the data ($F{data}) displays correcly (with the '‰') in data retrieved and displayed in a browser.

 

 

The xml file has encoding="UTF-8".

 

Please help.