AnsweredAssumed Answered

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

Question asked by mike54 on Oct 20, 2007
Latest reply on Oct 20, 2007 by mike54

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(

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

Thanks for any suggestions!