dawy Posted February 25, 2009 Share Posted February 25, 2009 Hi everyoneI 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.Driverurl: jdbc:mysql://localhost:3306/dawyserver?useUnicode=true&characterEncoding=UTF-8username: jasperdbpassword: 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 Link to comment Share on other sites More sharing options...
dawy Posted February 25, 2009 Author Share Posted February 25, 2009 Please HELP ME Link to comment Share on other sites More sharing options...
teodord Posted March 5, 2009 Share Posted March 5, 2009 Hi, Is this about an Ad-Hoc report in JasperServer Professional? Thank you,Teodor Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now