News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

product description

Started by johnrobie, December 23, 2011, 11:23:41 AM

Previous topic - Next topic

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

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

rupesh

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]

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/