Problem with latin characters

[dawy]

Hi everyone

I have a little problem with the latin characters (ó, í, á, etc.) on the reports section of the jaspersoft bi suite. I'll try to explain the issue:

 

Tomcat an MySQL versions: The jaspersoft-pro installer version

• On mysql table "X"  i have:

|| id || name | |

| 1 | López |

| 2 | Gómez |

the latin characters are ok

•  on C:jaspersoft-proapache-tomcatwebappsjasperserver-proMETA-INF context.xml

<Context path="/jasperserver-pro"
            debug="5" reloadable="true" crossContext="true">

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
            username="jasperdb" password="password" driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://127.0.0.1:3306/jasperserver?useUnicode=true&characterEncoding=UTF-8"/>

<Resource name="jdbc/dawyserver" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
            username="jasperdb" password="password" driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://127.0.0.1:3306/dawyserver?useUnicode=true&characterEncoding=UTF-8"/>
       
</Context>

• on Data Source (at BI Suite) i have:

controller: com.mysql.jdbc.Driver

url: jdbc:mysql://localhost:3306/dawyserver?useUnicode=true&characterEncoding=UTF-8

username: jasperdb

password: password
 

But when i create a table with the data records (at BI Suite) the table looks something like this:

|| id || name | |

| 1 | L¢pez |

| 2 | G¢mez |

 the special latin characters change for other characters. By the way the version of the BI has menus and features on spanish but on these the latin characters are ok, the problem is only with data on the tables. (on IE and Mozilla Firefox)

Could you help me??? how can i solve the issue???

Thanks in advance

 

Code:

Post Edited by Dawy Dawy at 02/25/09 23:33

[dawy]

Please HELP ME

[teodord]

Hi,

 

Is this about an Ad-Hoc report in JasperServer Professional?

 

Thank you,

Teodor