topic Lower in upper case mix in the table names in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lower-in-upper-case-mix-in-the-table-names/m-p/143553#M100437 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I ran into an issue while migrating my Activiti MySQL database from Windows to Linux server. Actually, the problem was in the case of the table names, that is ignored under Windows and is taken into account on Linux. I added the "lower_case_table_names=1" option to my Windows MySQL server configuration and regenerated the tables. Now I have both uppercase and lowercase table names in the schema. It seems to work now on both operation systems, but this mix of cases looks a bit suspicious to me. Is it normal to have such a structure? Did anyone already notice something similar when running Activiti with MySQL?</SPAN><BR /><SPAN>Activiti version : 5.12.1</SPAN><BR /><SPAN>MySQL version : 5.1.65</SPAN><BR /><SPAN>Show tables :</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />ACT_GE_BYTEARRAY<BR />ACT_GE_PROPERTY<BR />ACT_HI_ATTACHMENT<BR />ACT_HI_COMMENT<BR />ACT_HI_TASKINST<BR />ACT_ID_GROUP<BR />ACT_ID_INFO<BR />ACT_ID_MEMBERSHIP<BR />ACT_ID_USER<BR />ACT_RE_DEPLOYMENT<BR />ACT_RE_MODEL<BR />ACT_RE_PROCDEF<BR />ACT_RU_EVENT_SUBSCR<BR />ACT_RU_EXECUTION<BR />ACT_RU_IDENTITYLINK<BR />ACT_RU_JOB<BR />ACT_RU_TASK<BR />ACT_RU_VARIABLE<BR />act_hi_actinst<BR />act_hi_detail<BR />act_hi_procinst<BR />act_hi_varinst<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sun, 28 Apr 2013 11:22:40 GMT pkokorev 2013-04-28T11:22:40Z Lower in upper case mix in the table names https://connect.hyland.com/t5/alfresco-archive/lower-in-upper-case-mix-in-the-table-names/m-p/143553#M100437 Hello,I ran into an issue while migrating my Activiti MySQL database from Windows to Linux server. Actually, the problem was in the case of the table names, that is ignored under Windows and is taken into account on Linux. I added the "lower_case_table_names=1" option to my Windows MySQL server conf Sun, 28 Apr 2013 11:22:40 GMT https://connect.hyland.com/t5/alfresco-archive/lower-in-upper-case-mix-in-the-table-names/m-p/143553#M100437 pkokorev 2013-04-28T11:22:40Z Re: Lower in upper case mix in the table names https://connect.hyland.com/t5/alfresco-archive/lower-in-upper-case-mix-in-the-table-names/m-p/143554#M100438 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Hmm that's strange indeed. The create script only contains upper case table names.</SPAN><BR /><SPAN>Just tested it and I got the same result. But I have no idea at the moment what's the cause of this. Will do some more investigation this week.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Mon, 29 Apr 2013 09:02:23 GMT https://connect.hyland.com/t5/alfresco-archive/lower-in-upper-case-mix-in-the-table-names/m-p/143554#M100438 trademak 2013-04-29T09:02:23Z