product description

[johnrobie]

Why is the product description database field limited to 2024 characters. It`s to short for my customer. I changed it from varchar to text. It works fine.
Does this cause any problems?

[Studio 42]

Hi,

Why is the product description database field limited to 2024 characters. It`s to short for my customer. I changed it from varchar to text. It works fine.
Does this cause any problems?

NO you can change it

[Milbo]

Johnrobie: This was the value of the RC3, we have now
varchar(2048) for the short description and
varchar(19000) for the normal description, the tos and things like this.

I suggest to use varchar, then the tables are readed faster.

[rupesh]

varchar(19000) for the normal description, the tos and things like this.

i just checked this it is showing varchar(18000) for product_desc in virtuemart_products_en_gb  table!
My question is Can we increase the size to 20000? or if we change that field to text then all the product desc totally disappears from the page? I need to store large product description for my data

i'm using joomla 2.5.1
and virtuemart 2.0.2

[attachment cleanup by admin]

[Milbo]

Please just read here http://forum.virtuemart.net/index.php?topic=101061.msg335055#msg335055