Option Value Length

[greatlakesherbalife]

Ver 1.8.X

How do I modify the length of the Option Value in the Option Names in Option Values Manager In the CP?
The current length appears to be about 64 characters.
I want to include HTML for example....
<A HREF="/images/3106vanilla.pdf" target="blank">French Vanilla</A>
I would also like to stretch the box, so I can see what I typed. Is this possible???? I have read thru the Zen Cart Book, Searched forums, and WIKI, and still no results!

I sort of had it working, until I exceded 64 characters. You can see it here....

http://greatlakesherbalife.com/index...&products_id=2

Under French Vanilla.

Thanks!
Kevin Holley
Great Lakes Herbalife

[Ajeh]

You can customize the products_options_values table and change the the field:
products_options_values_name

You can try changing that to the type of TEXT and see if that works better for you ...

[greatlakesherbalife]

That won't work. I have Flavors and sizes and each flavor has a different label. I need to show that label, and so far, adding HTML to my Option Name is the closest I have come.

[Ajeh]

If you make the field type in the database table TEXT rather than varchar 64 ... then the field can contain a lot more than 64 characters ...

[greatlakesherbalife]

Are you talking about making this change in the database??? Rather than in the CP???

[Ajeh]

Yes I am ... if you want to enter as an Option Value something longer than 64 characters ... that data is stored in the database in the products_options_values table and you need to change the field:
products_options_values_name

so that instead of being varchar 64 it is something bigger such as text ...