3 Aug
2009
3 Aug
'09
6:05 p.m.
Matthias.Gsottberger(a)o2.com wrote:
Hi!
We have a problem with the encoding of special characters like german
umlauts since XWiki Enterprise 1.9.2.22089. In earlier 1.8 versions of
xWiki we had no problem with the encoding still you changed the default
encoding to UTF-8.
Our Database Encoding is set to ISO-8859-1 and we cannot change this.
We tried to change the encoding parameters in following files without
success:
xwiki.cfg: xwiki.encoding = ISO-8859-1
web.xml: <filter>
<init-param>
<param-name>encoding</param-name>
<param-value>ISO-8859-1</param-value>
</init-param>
</filter>
hibernate.cfg.xml:
<property name="connection.useUnicode">false</property>
<property
name="connection.characterEncoding">ISO-8859-1</property>
What else should we change to save special characters properly ?
Please check the connection URL, too. The default one contains encoding
settings, too:
<property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property>
What exactly is the behavior? Do characters end up as two or three
characters? Are they replaced by question marks after a while? Do you
get an exception when trying to save the document?
--
Sergiu Dumitriu
http://purl.org/net/sergiu/