Chinese UTF woes

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

durianwool

Hi,

I just installed Alf 2.1 linux from the tomcat distro. I am installing with MySQL on a OpenSuse 10.2. Chinese (simplified) chars for filenames cannot be accepted nor displayed on the web gui nor the system.

I suspected its due to the MySQL cos HSQL works, but I can't / shouldn't use that for production right?  I tried this after failing miserably miserably at trying to migrate Alf 2.0 HSQL to Alf 2.0 MySQL. But now even a fresh install of Alf 2.1 with MySQL 5.0 still can't work propoerly (due to this Chinese problem) … so I had to rollback to Alf 2.0 with HSQL now…


I changed the db_setup.sql script as follows:

create database alfresco CHARACTER SET utf8 COLLATE utf8_general_ci;

But I still got the same prob. I even reset the MySQL 5.0 be UTF8 by default. but still failed miserably. I got an ugly error that won't even initiate alfresco:

20:33:11,294 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
20:33:12,159 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@166fdde
Caused by:
org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@166fdde
        at org.alfresco.repo.transaction.RetryingTran …

So I then reverted the DB back to latin1, though the alfresco DB itself is UTF8 now… Only then it initialises - but then I get back to square one that I can't put Chinese filenames and chars. Only these settings work:

mysql> status
————–
mysql  Ver 14.12 Distrib 5.0.26, for suse-linux-gnu (i686) using readline 5.1

Connection id:          1
Current database:       alfresco
Current user:           root@localhost
SSL:                    Not in use
Current pager:          less
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.26
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 20 min 17 sec

Is there some settings in Alf 2.1 community itself?!?!?!?
Argh!


BR,

Durian

kevinr

I think it all needs to be utf-8 - these are the settings from my MySQL 5.0.18 instance:

mysql> status
————–
mysql  Ver 14.12 Distrib 5.0.18, for Win32 (ia32)

Connection id:          958
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.18-nt-max
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 18 days 56 min 26 sec