Jasper Report arabic query problem

I'm trying to make a report in jasper the report query contains this where statement

where payment='شيك'

when I try to run the report using the JRViewer300 I got the following exception

net.sf.jasperreports.engine.fill.JRExpresssionEvalException : Error evaluating expression...

When I change the where statement to

where payment='cheque'

开发者_Go百科

the report runs without any problem. So what is all this about?

Thanks

---

I assume that the database is set to work with UNICODE encoding, In Java you need to escape the input string (treat special chars) and turn the encoding to UTF-8 ( or 16) Check this out.

...and also try this:

exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, "UTF-8");