extra fields length

Jeanjaques · #1 10-15-2006, 01:10 AM

Hi!
i ╢ve the problem that my extra field product description won╢t show me more than 255 characters.

how can i change this? because the description depends between 100-500 characters?

using x-cart 4.1.1

thx

balinor · #2 10-15-2006, 04:26 AM

Are you talking about Extra Fields or the product description?

Jeanjaques · #3 10-15-2006, 07:25 AM

only the extra fields...

balinor · #4 10-15-2006, 07:46 AM

Are you familiar with PHPMyAdmin? You would need to make an adjustment to a table in there....

Jeanjaques · #5 10-15-2006, 09:20 AM

ah ok!
thats what i wanted to know!
so its not an prob from x-cart, its a problem of the sql table...

can you tell me wich table it is?
thx

balinor · #6 10-15-2006, 09:22 AM

It is the extra_fields table....a couple different fields..change VARCHAR(255) to TEXT and that will open it right up for you.

phpmattk · #7 02-05-2007, 01:30 PM

As of v 4.1.5 the field you want is in the 'xcart_extra_field_values' table and you'll want to change the 'value' fields datatype to text, blob, etc

nivag · #8 01-15-2009, 08:41 AM

Anyone know how to make this change in 4.2 ? I have tried changing datatype to text but makes no difference...