2

in Mage setup sql scripts how do you add a column with text size medium? I'm not sure the 64kb limit of TYPE_TEXT will be long enough.

->addColumn('comments',Varien_Db_Ddl_Table::TYPE_TEXT,null,array(),'Comments')

1 Answer 1

0

Take a look at this: https://stackoverflow.com/questions/10074358/how-to-increase-maximum-size-of-csv-field-in-magento-where-is-this-located

Apparently you have to manually change the type of the field but it seems risky. One of the answers claims to have done it without any problems though.

Alternatively, you could try to estimate if your field will really need more space. MySQL type TEXT can fit a bit over 65, 000 characters.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.