Hi all, We are facing a weird issue. The following code (provided the right host name, username and password)... áéíóú <% import groovy.sql.Sql db = Sql.newInstance("jdbc:mysql://hostname/database", "username", "password", "com.mysql.jdbc.Driver") List samplesIA = db.rows('SELECT * FROM saltmines s where es like "I" and ess like "A" and ids>=1') %> Tomáronse un total de <% println "${samplesIA.size()}"%> mostras da secuencia sedimentaria do perfil P3-6-IA. Edited by any user but admin with programming rights is rendered as... http://mire.environmentalchange.net/~webmaster/images/RightCharaters.png Edited by admin it is rendered this other way... http://mire.environmentalchange.net/~webmaster/images/WrongCharacters.png Please, not the question marks and the absence of the number 32. This happens with any page containing Groovy code in this server, but I am not able to reproduce the problem in my test environment. Both of them run 1.3-milestone-1.7186. Please, do you know why this could happen? Thanks! Best regards, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Hi all, We are facing a weird issue. The following code (provided the right host name, username and password)... áéíóú <% import groovy.sql.Sql db = Sql.newInstance("jdbc:mysql://hostname/database", "username", "password", "com.mysql.jdbc.Driver") List samplesIA = db.rows('SELECT * FROM saltmines s where es like "I" and ess like "A" and ids>=1') %> Tomáronse un total de <% println "${samplesIA.size()}"%> mostras da secuencia sedimentaria do perfil P3-6-IA. Edited by any user but admin with programming rights is rendered as... http://mire.environmentalchange.net/~webmaster/images/RightCharaters.png Edited by admin it is rendered this other way... http://mire.environmentalchange.net/~webmaster/images/WrongCharacters.png Please, not the question marks and the absence of the number 32. This happens with any page containing Groovy code in this server, but I am not able to reproduce the problem in my test environment. Both of them run 1.3-milestone-1.7186. Please, do you know why this could happen? Thanks! Best regards, Ricardo

Sergiu Dumitriu wrote: Hi Sergiu: It is easy to find the xwiki.encoding value. Here it is: xwiki.encoding=ISO-8859-1 But I am not sure about what value I must give you as file.encoding jvm property. I've not URIEncoding in the Tomcat connector, and I don't find any file.encoding thing in catalina.sh. Please, could you tell me where must I look for this value? Tomcat's web.xml reads <?xml version="1.0" encoding="ISO-8859-1"?>. No encoding find in catania.sh, nor in startup.sh. A simple .jsp gives us the file.encoding value as: System.getProperty("file.encoding"): ANSI_X3.4-1968

OutputStreamWriter encoding is: ASCII I've not touched neither Tomcat nor XWiki encoding default configuration. Or at least I am not aware of that. But the curiouse is that this server has been working apparently fine (concerning encoding) until the last update.

I know this is not a XWiki issue, but any help will be really welcome. Thank you so much, Ricardo

Yep, that's the value I'm interested in. If you can change the tomcat settings, can you you add -Dfile.encoding=ISO-8859-1, restart tomcat and test again?

Actually, we're trying to make this automatic, so that no system settings must be changed. I hope this will work in the final 1.3 release.