topic Re: Data too long for column 'TEXT_' at row 1 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250078#M203208 <HTML><HEAD></HEAD><BODY><SPAN>Yes, definitely store it as content. If the datatable is related to some other node, you could store the datatable's node as a child object of the node it relates to.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Wed, 28 Mar 2012 16:44:19 GMT jpotts 2012-03-28T16:44:19Z Data too long for column 'TEXT_' at row 1 https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250077#M203207 Hello,Iam using a text field to store the value of a datatable (http://developer.yahoo.com/yui/datatable/). All is working good but I can't put enough data inside.As I know the TEXT in alfresco with Mysql is define to 4000 chars.How can use to store more data ?Perhaps I should use d:content (https:/ Wed, 28 Mar 2012 07:52:24 GMT https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250077#M203207 dranakan 2012-03-28T07:52:24Z Re: Data too long for column 'TEXT_' at row 1 https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250078#M203208 <HTML><HEAD></HEAD><BODY><SPAN>Yes, definitely store it as content. If the datatable is related to some other node, you could store the datatable's node as a child object of the node it relates to.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Wed, 28 Mar 2012 16:44:19 GMT https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250078#M203208 jpotts 2012-03-28T16:44:19Z Re: Data too long for column 'TEXT_' at row 1 https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250079#M203209 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>Is it a good idea to change in the database from type varchar(4000) to MEDIUMTEXT or LONGTEXT ?</SPAN><BR /><SPAN>(with Mysql, table act_hi_detail and act_ru_variable)</SPAN><BR /><BR /><SPAN>I think that I will have problem in the future with new version of Alfresco (during updates…)</SPAN></BODY></HTML> Tue, 05 Jun 2012 08:06:58 GMT https://connect.hyland.com/t5/alfresco-archive/data-too-long-for-column-text-at-row-1/m-p/250079#M203209 dranakan 2012-06-05T08:06:58Z