topic Data too long for column 'TEXT_' at row 1 in Alfresco Archive

Data too long for column 'TEXT_' at row 1

dranakan — Wed, 28 Mar 2012 07:52:24 GMT

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:/

Re: Data too long for column 'TEXT_' at row 1

jpotts — Wed, 28 Mar 2012 16:44:19 GMT

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.

Jeff

Re: Data too long for column 'TEXT_' at row 1

dranakan — Tue, 05 Jun 2012 08:06:58 GMT

Hello,

Is it a good idea to change in the database from type varchar(4000) to MEDIUMTEXT or LONGTEXT ?
(with Mysql, table act_hi_detail and act_ru_variable)

I think that I will have problem in the future with new version of Alfresco (during updates…)