[xwiki-users] Encoding problem with external database
Hi, I am using XWiki with external database with my own data. I am using SQL plugin. When I run this simple script: ------------------------------------------------------------------------ #set ($mydb=$xwiki.sql.getDatabase("jdbc/xwiki_conference")) $mydb.executeUpdate("UPDATE table SET title = 'ěščřžýáí' WHERE id = 1"); ------------------------------------------------------------------------ - I get "?š??žýáí" saved in the database. My web.xml and xwiki.cfg are set to UTF-8, database has utf8_general_ci as encoding. What else should I change to save the characters properly? -- View this message in context: http://n2.nabble.com/Encoding-problem-with-external-database-tp2645316p26453... Sent from the XWiki- Users mailing list archive at Nabble.com.
Zik23 wrote:
Hi, I am using XWiki with external database with my own data. I am using SQL plugin.
When I run this simple script:
------------------------------------------------------------------------ #set ($mydb=$xwiki.sql.getDatabase("jdbc/xwiki_conference"))
$mydb.executeUpdate("UPDATE table SET title = 'ěščřžýáí' WHERE id = 1"); ------------------------------------------------------------------------
- I get "?š??žýáí" saved in the database.
My web.xml and xwiki.cfg are set to UTF-8, database has utf8_general_ci as encoding.
What else should I change to save the characters properly?
Check the encoding of the connection. -- Sergiu Dumitriu http://purl.org/net/sergiu/
Check the encoding of the connection. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users Thanks for a quick response, this could be the problem. But where do I set the encoding of the connection? -- View this message in context: http://n2.nabble.com/Encoding-problem-with-external-database-tp2645316p26507... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (2)
-
Sergiu Dumitriu -
Zik23