If I create a new attribute as text area, what is the maximum character limit that I can put there? Is it possible to increase that limit?
I want to create a product attribute of type LONG TEXT. Is it possible?
databasemagento-1.9product-attribute
If I create a new attribute as text area, what is the maximum character limit that I can put there? Is it possible to increase that limit?
I want to create a product attribute of type LONG TEXT. Is it possible?
Best Answer
The text attributes are stores in the table
catalog_product_entity_text
. Their values are stores in thevalue
column that is of typetext
.You can see here the max lengths allowed for all column types.
This is what's important to you:
You can also use long text for an attribute, but this is more complicated. You would have to create a table similar to
catalog_product_entity_text
but with the columnvalue
having the type LONGTEXT.THe max storage for this is (from the same source)
But you will also have to search through the code to see where you need to tell magento to consider your new table. I have no idea what this will take.
I suggest using the TEXT attribute. It should be enough storage. If you plan to keep more than 64k in one column you might need to rethink your architecture.