Add "set names" statements to the query

[ldcl289]

 How can I add a "set names 'latin'" to execute previous the real query, that because I have problems with some character like "ñ" and acents.

I try adding the line in the begin of <queryString> but doesn't work, it give me a sql error.

I try differents ways but nothing work!!

Can somebody helpme? 

Code:

<queryString><![CDATA[sET NAMES 'latin1';SELECT p.id AS 'id'....

[lucianc]

You can't do that in the report query.  If you run the reports from your own code, you can prepare the connection before sending it to the report.  Or you can look for a JDBC parameter that sets the character encoding.

Regards,

Lucian