topic Chinese UTF woes in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/chinese-utf-woes/m-p/120632#M85025 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>I suspected its due to the MySQL cos HSQL works, but I can't / shouldn't use that for production right?&nbsp; I tried this after failing miserably </SPAN><A href="http://forums.alfresco.com/viewtopic.php?p=31673#31673" rel="nofollow noopener noreferrer">miserably at trying to migrate Alf 2.0 HSQL to Alf 2.0 MySQL</A><SPAN>. 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…</SPAN><BR /><BR /><BR /><SPAN>I changed the db_setup.sql script as follows:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">create database alfresco CHARACTER SET utf8 COLLATE utf8_general_ci;</BLOCKQUOTE><BR /><SPAN>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:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">20:33:11,294 WARN&nbsp; [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one<BR />20:33:12,159 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed<BR />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<BR />Caused by:<BR />org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@166fdde<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTran …</BLOCKQUOTE><BR /><SPAN>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:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">mysql&gt; status<BR />————–<BR />mysql&nbsp; Ver 14.12 Distrib 5.0.26, for suse-linux-gnu (i686) using readline 5.1<BR /><BR />Connection id:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1<BR />Current database:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alfresco<BR />Current user:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; root@localhost<BR />SSL:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Not in use<BR />Current pager:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; less<BR />Using outfile:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ''<BR />Using delimiter:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;<BR />Server version:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.0.26<BR />Protocol version:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10<BR />Connection:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Localhost via UNIX socket<BR />Server characterset:&nbsp;&nbsp;&nbsp; latin1<BR />Db&nbsp;&nbsp;&nbsp;&nbsp; characterset:&nbsp;&nbsp;&nbsp; utf8<BR />Client characterset:&nbsp;&nbsp;&nbsp; latin1<BR />Conn.&nbsp; characterset:&nbsp;&nbsp;&nbsp; latin1<BR />UNIX socket:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /var/lib/mysql/mysql.sock<BR />Uptime:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 min 17 sec</BLOCKQUOTE><BR /><SPAN>Is there some settings in Alf 2.1 community itself?!?!?!?</SPAN><BR /><SPAN>Argh!</SPAN><BR /><BR /><BR /><SPAN>BR,</SPAN><BR /><BR /><SPAN>Durian</SPAN></BODY></HTML> Thu, 08 Nov 2007 13:01:51 GMT durianwool 2007-11-08T13:01:51Z Chinese UTF woes https://connect.hyland.com/t5/alfresco-archive/chinese-utf-woes/m-p/120632#M85025 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 produ Thu, 08 Nov 2007 13:01:51 GMT https://connect.hyland.com/t5/alfresco-archive/chinese-utf-woes/m-p/120632#M85025 durianwool 2007-11-08T13:01:51Z Re: Chinese UTF woes https://connect.hyland.com/t5/alfresco-archive/chinese-utf-woes/m-p/120633#M85026 <HTML><HEAD></HEAD><BODY><SPAN>I think it all needs to be utf-8 - these are the settings from my MySQL 5.0.18 instance:</SPAN><BR /><BR /><SPAN>mysql&gt; status</SPAN><BR /><SPAN>————–</SPAN><BR /><SPAN>mysql&nbsp; Ver 14.12 Distrib 5.0.18, for Win32 (ia32)</SPAN><BR /><BR /><SPAN>Connection id:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 958</SPAN><BR /><SPAN>Current database:</SPAN><BR /><SPAN>Current user:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; root@localhost</SPAN><BR /><SPAN>SSL:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Not in use</SPAN><BR /><SPAN>Using delimiter:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;</SPAN><BR /><SPAN>Server version:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.0.18-nt-max</SPAN><BR /><SPAN>Protocol version:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</SPAN><BR /><SPAN>Connection:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; localhost via TCP/IP</SPAN><BR /><SPAN>Server characterset:&nbsp;&nbsp;&nbsp; utf8</SPAN><BR /><SPAN>Db&nbsp;&nbsp;&nbsp;&nbsp; characterset:&nbsp;&nbsp;&nbsp; utf8</SPAN><BR /><SPAN>Client characterset:&nbsp;&nbsp;&nbsp; utf8</SPAN><BR /><SPAN>Conn.&nbsp; characterset:&nbsp;&nbsp;&nbsp; utf8</SPAN><BR /><SPAN>TCP port:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3306</SPAN><BR /><SPAN>Uptime:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18 days 56 min 26 sec</SPAN></BODY></HTML> Fri, 16 Nov 2007 18:25:28 GMT https://connect.hyland.com/t5/alfresco-archive/chinese-utf-woes/m-p/120633#M85026 kevinr 2007-11-16T18:25:28Z