Jasperreports charset problem

Classic Servoy
1

Hi,
im workin on servoy 6.0.0 and using the latest jasper plugin with ireport 3.7.1, im workin over dbfs
im having problems showing some special characters like accent marks (á é í ó ú). the thing is that in static text i use them with no problem but in the data it gets from the query they’re not shown correctly while if i get that same data on servoy or on some other program (using the same odbc connection that jasper uses) they’re correctly shown so i think my problem comes to jasper or some configuration im not gettin right.
I’ve tryied a few things but nothing worked so far, any ideas?

thanks in advance

2

I’ve done some more research using servoy sqlExplorer and it seems that my problem comes to my conecction jdbc:odbc, because when i tryied before i used razorsql to connect directly to the odbc and it got the data correctly. is there something i can add to the conecction as a parameter maybe or something like that?

3

im now using jdbc:odbc:foxpro;charSet=Cp1252 the charset parameter to my conecction but perhaps im missing something, still doesnt work