VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: johnrobie on December 23, 2011, 11:23:41 AM

Title: product description
Post by: johnrobie on December 23, 2011, 11:23:41 AM
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?
Title: Re: product description
Post by: Studio 42 on December 23, 2011, 12:48:44 PM
Hi,
Quote from: johnrobie on December 23, 2011, 11:23:41 AM
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
Title: Re: product description
Post by: Milbo on December 24, 2011, 10:52:26 AM
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.
Title: Re: product description
Post by: rupesh on April 12, 2012, 16:16:21 PM
Quote from: Milbo on December 24, 2011, 10:52:26 AM

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]
Title: Re: product description
Post by: Milbo on April 13, 2012, 01:15:27 AM
Please just read here http://forum.virtuemart.net/index.php?topic=101061.msg335055#msg335055