topic Re: Problems with native characters - urgent, plz help! in Alfresco Archive

Problems with native characters - urgent, plz help!

maggot84 — Tue, 22 Apr 2008 14:00:26 GMT

Hi, I'm new to the Alfresco Community and am in desperate need of help 'cause I've come across an issue that I can't seem to work out by myself.I've searched a large part of this forum, but unfortunately none of the related topics provided me with a solution, so I've submited a new one.I'm using the

Re: Problems with native characters - urgent, plz help!

steve — Tue, 22 Apr 2008 14:51:00 GMT

Hi,

This would indicate that your MySQL install is using the default characterset of Latin-1.
You need to change MySQL to use UTF-8.

You can change the default for MySQL using the following entries in your my.ini or my.cnf config files:


[mysql]
…
default-character-set=utf8
…
[mysqld]
default-character-set=utf8
…
‍‍‍‍‍‍‍‍‍

You will need to restart MySQL after making these changes, and also you will need to drop and recreate your Alfresco schema (don't forget to also delete your contents of the alf_data dir).

You can also change the settings used by your MySQL connector by modifying the settings in your custom-repository.properties file to:


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

Steve

Re: Problems with native characters - urgent, plz help!

maggot84 — Wed, 23 Apr 2008 09:09:31 GMT

That did the trick!
Thank you very, very, very much!

Re: Problems with native characters - urgent, plz help!

steve — Mon, 28 Apr 2008 09:48:58 GMT

No problem, glad that helped.

Steve