Is it possible to make product description hold more characters

[websmith]

JM 3.4.8
VM 3.0.12

Ive searched but cant seem to find a way to expand the product description field to hold long descriptions greater than 18k characters. Is this possible? and where would I make the edit?

Thank you

[jjk]

JM 3.4.8
VM 3.0.12

Ive searched but cant seem to find a way to expand the product description field to hold long descriptions greater than 18k characters. Is this possible? and where would I make the edit?

You might find useful information if you search for: product_desc 18400

[Studio 42]

DO NOT CHANGE IT !

Virtuemart force on update to use the original limitation, so any char more get removed when you update Virtuemart.
If you need more text, add a product customfield type editor, or if you need more, you can do a simple plugin for this using a new table to store. ( This is a slower solution but have no limit )

[Milbo]

This is just wrong Patrick, since many years we have the virtuemart.cfg file to keep configurations, which are important for installation and updates.

Please read here http://docs.virtuemart.net/manual/general-concepts/206-hidden-configurations.html

use dblayoutstrict with false and you get text instead of varchar

[Studio 42]

Hi Max,
In table updater, this revert the changes if you don't pay attention, or not ?

[Milbo]

No, the tableupdater reads the values from the config, when there is no config, then from the file.

[Studio 42]

SO the solution for this case is to create a virtuemart.cfg file with only one line
dblayoutstrict=0
If i have understand correctly ?
So the table updater do not update product table on next update with the varchar 18400 for description.

[Milbo]

http://docs.virtuemart.net/manual/general-concepts/206-hidden-configurations.html

HOW TO USE A HIDDEN CONFIGURATION PARAMETER?

open the virtuemart.cfg (at /administrator/components/com_virtuemart/virtuemart.cfg)
Preset any value used in VmConfig::get('myvalue','default').
In the example, change the line myvalue=default to myvalue=mydefaultvalue
Save the file
Enter the virtuemart backend:
For VirtueMart 3: store the configuration file once. The configuration file is load first and overwritten by the form and you should keep all settings.
For VirtueMart 2: you must use the button in tools "udpate config by file". Be aware that you loose your settings then.