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

[mike54]

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 2003
Apache Tomcat 6.0
MySQL 5.0.45
Alfresco Comunity 2.1

I have managed to make everything working (except for OpenOffice running as a service) and strange encoding problems.

Instructions said "for non-English or non-West European languages, choose UTF8 Character set" so I have modified db_setup.sql:

CREATE DATABASE alfresco CHARACTER SET utf8 COLLATE utf8_general_ci; ‍

Now all tables in DB are created as UTF-8 (instead of Latin1).
The page encoding is automatically set to UTF-8.
I was sure it will work now… but for example user names and space names are still stored and displayed incorectly (the value in the DB is wrong and contains '?' instead of national character)

Whats more Alfresco encounters error when I try to delete a space that has national characters in the name! (when I rename I can delete without any problems)

01:16:21,909 ERROR [org.alfresco.web.ui.common.Utils] Unable to delete Space due to system error:

javax.transaction.RollbackException: Transaction didn't commit: Integrity failure at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:412)‍‍‍

Is it OK that wrong user defined space name can cause errors…?

Thanks for any suggestions!
Regards
Mike

[mike54]

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!

[mike54]

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!