MySQL Character Encoding Configuration

It's common practice that the MySQL configuration file, in *nix systems is located in /etc/mysql/my.cnf
in windows, which is located in %MYSQL_HOME%\my.ini

[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci

XWiki encoding

web.xml:

<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>com.xpn.xwiki.web.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>


xwiki.cfg:

xwiki.encoding = UTF-8

XWiki: XWikiPreferences:
Default Language:en