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
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.