How can I add "set names 'latin1'" in jasperreports

Question

I have problems with some character display, like "ñ" and accents in my reports, so I want to add previously to the query "set name 'latin1';" but jasper doesn't work, that because when I run the query in phpmyadmin with this line it works. The applicaton in php work fine, don't has a problem with the characters

Thanks

Answer 1

Have a look at:

Turning MySQL data in latin1 to utf8 utf-8