cancel
Showing results for 
Search instead for 
Did you mean: 

How change quote table customer_note column type to text

How change quote table customer_note column type to text

I tried to update the quote table customer_note column type to text using setup script and schema patch. Column type updated after run setup:upgrade but when I run setup:upgrade the second time then column type revert to varchar as previously. This issue because Magento creates a quote table using declarative schema. How I can extend that db_schema.xml file in my custom module to change customer_note column type to text.

I review this link https://magento.stackexchange.com/questions/304324/magento2-3-how-to-set-text-column-table-value-def... and follow steps but I got Invalid Document Element 'column', attribute 'length': The attribute 'length' is not allowed. Error while run setup:upgrade command