topic Re: Encoding problem and errors (Unable to delete Space), help! in Alfresco Archive

Encoding problem and errors (Unable to delete Space), help!

mike54 — Sat, 20 Oct 2007 00:44:00 GMT

Hi! I'm strugling with my first Alfresco 2.1 installation. I want it to work as a service under windows, so I'm not using the ready boundle.My system is:Windows Server 2003Apache Tomcat 6.0MySQL 5.0.45Alfresco Comunity 2.1I have managed to make everything working (except for OpenOffice running as a

Re: Encoding problem and errors (Unable to delete Space), help!

mike54 — Sat, 20 Oct 2007 09:09:52 GMT

Simmiliar topics but no solution for me

National character metadata extraction
http://forums.alfresco.com/viewtopic.php?t=9036&highlight=utf8

Store content properties in local languages
http://forums.alfresco.com/viewtopic.php?t=8072&highlight=utf8

Spce name in Chinese
http://forums.alfresco.com/viewtopic.php?t=8148&highlight=utf8

Well, I'm not using Chineese but Polish - results are the same- it's not working I also have vTiger CRM installation on another MySQL and absolutelly no problems with encoding!

Re: Encoding problem and errors (Unable to delete Space), help!

mike54 — Sat, 20 Oct 2007 10:08:11 GMT

OK! I have solved te problem!

First I have created DB with

CHARACTER SET utf8
and COLLATE utf8_general_ci‍‍

I thing alternativelly you can set

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

Additionally I have modified my.ini located in MySQL folder:
[mysql]
default-character-set=utf8

Be carefull not to use 'UTF-8' just 'utf8'
than the DB was populated with tables in UTF-8 by Alfresco

And the space names apper to work corectly!