Change product description length in VirttureMart 3.0.8

[simon127]

Hi,

Please can someone help me, I trying to add a product with a very long description. Think it is set to about 2000 words, is there anyway I can make this longer?

Using Joomla 3.4.1 and VM 3.0.8.

Sorry if this has been asked before, but I really can't find an answer or might be looking in the wrong place.

Many thanks in advance.
Simon

[Studio 42]

Hi,
I don't know why product desc is type of varchar.
Simply read this post : http://nicj.net/mysql-text-vs-varchar-performance/
YOu can run (do not  forget to change the XX by your values)
ALTER TABLE `XXX_virtuemart_products_XX_XX` CHANGE `product_desc` `product_desc` CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
or use phpmyadmin and change the field from var_char to text in structure tab.

text can save 65 536 char
Of course you can change the size of varchar.