News:

Support the VirtueMart project and become a member

Main Menu

Change product description length in VirttureMart 3.0.8

Started by simon127, June 29, 2015, 17:21:46 PM

Previous topic - Next topic

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.