A fix for Alfresco/MySQL unicode encoding

[ismail_sidiya]

Hi all
I have been experiencing the character encoding issue when working with multilingual content. I was able to fix it by editing the jdbc url and adding in relevant connection properties like this :

db.url=jdbc:mysql://localhost/alfresco?useUnicode=true&characterEncoding=utf-8‍

I've tested it with chinese, russion and arabic
I'm posting it here to make it easier for others to find

Hope this help

[sacco]

Thanks, that looks useful.

[musper]

Once again thanks for this tip…
Oh…for other fresh users out there, the file where you have to change this line is located on windows systems under X:\alfresco\tomcat\shared\classes\alfresco\extension\custom-repository.properties