topic Encoding problem and errors (Unable to delete Space), help! in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140126#M98151 <HTML><HEAD></HEAD><BODY><SPAN>Hi! </SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>My system is:</SPAN><BR /><SPAN>Windows Server 2003</SPAN><BR /><SPAN>Apache Tomcat 6.0</SPAN><BR /><SPAN>MySQL 5.0.45</SPAN><BR /><SPAN>Alfresco Comunity 2.1</SPAN><BR /><BR /><SPAN>I have managed to make everything working (except for OpenOffice running as a service) and strange encoding problems.</SPAN><BR /><BR /><SPAN>Instructions said "for non-English or non-West European languages, choose UTF8 Character set" so I have modified db_setup.sql:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>CREATE DATABASE alfresco CHARACTER SET utf8 COLLATE utf8_general_ci; <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> </SPAN><BR /><SPAN>Now all tables in DB are created as UTF-8 (instead of Latin1).</SPAN><BR /><SPAN>The page encoding is automatically set to UTF-8.</SPAN><BR /><SPAN>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)</SPAN><BR /><BR /><SPAN>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)</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>01:16:21,909 ERROR [org.alfresco.web.ui.common.Utils] Unable to delete Space due to system error:<BR /><BR />javax.transaction.RollbackException: Transaction didn't commit: Integrity failure at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:412)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Is it OK that wrong user defined space name can cause errors…?</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Thanks for any suggestions!</SPAN><BR /><SPAN>Regards</SPAN><BR /><SPAN>Mike</SPAN></BODY></HTML> Sat, 20 Oct 2007 00:44:00 GMT mike54 2007-10-20T00:44:00Z Encoding problem and errors (Unable to delete Space), help! https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140126#M98151 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 Sat, 20 Oct 2007 00:44:00 GMT https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140126#M98151 mike54 2007-10-20T00:44:00Z Re: Encoding problem and errors (Unable to delete Space), help! https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140127#M98152 <HTML><HEAD></HEAD><BODY><SPAN>Simmiliar topics but no solution for me</SPAN><BR /><BR /><SPAN>National character metadata extraction</SPAN><BR /><A href="http://forums.alfresco.com/viewtopic.php?t=9036&amp;highlight=utf8" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=9036&amp;highlight=utf8</A><BR /><BR /><SPAN>Store content properties in local languages</SPAN><BR /><A href="http://forums.alfresco.com/viewtopic.php?t=8072&amp;highlight=utf8" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=8072&amp;highlight=utf8</A><BR /><BR /><SPAN>Spce name in Chinese</SPAN><BR /><A href="http://forums.alfresco.com/viewtopic.php?t=8148&amp;highlight=utf8" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=8148&amp;highlight=utf8</A><BR /><BR /><SPAN>Well, I'm not using Chineese but Polish - results are the same- it's not working <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /> I also have vTiger CRM installation on another MySQL and absolutelly no problems with encoding!</SPAN></BODY></HTML> Sat, 20 Oct 2007 09:09:52 GMT https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140127#M98152 mike54 2007-10-20T09:09:52Z Re: Encoding problem and errors (Unable to delete Space), help! https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140128#M98153 <HTML><HEAD></HEAD><BODY><SPAN>OK! I have solved te problem!</SPAN><BR /><BR /><SPAN>First I have created DB with </SPAN><BR /><PRE class="language-none line-numbers"><CODE>CHARACTER SET utf8<BR />and COLLATE utf8_general_ci<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I thing alternativelly you can set </SPAN><BR /><PRE class="language-none line-numbers"><CODE>[mysqld]<BR />default-character-set=utf8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>Additionally I have modified my.ini located in MySQL folder:</SPAN><BR /><SPAN>[mysql]</SPAN><BR /><SPAN>default-character-set=utf8</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Be carefull not to use 'UTF-8' just 'utf8'</SPAN><BR /><SPAN>than the DB was populated with tables in UTF-8 by Alfresco</SPAN><BR /><BR /><SPAN>And the space names apper to work corectly!</SPAN></BODY></HTML> Sat, 20 Oct 2007 10:08:11 GMT https://connect.hyland.com/t5/alfresco-archive/encoding-problem-and-errors-unable-to-delete-space-help/m-p/140128#M98153 mike54 2007-10-20T10:08:11Z