Changing the max field length of attributes/product options

[HeyItsCory]

I'm trying to stick HTML code in the option name and comments of product options so for a couple things it will show up as a button that will open a new window full of fabric swatches. The problem is, I only seem to have 32 characters to work with for the product options and 70-something for the comments (instructions). Is there a way to up this limit so I can have enough room to type in an <A HREF=""> and <IMG SRC=""> and some other HTML to get rid of borders and such?

 

This seems like one of those things that will be very very simple, or very very... not.

[HeyItsCory]

So people understand what I'm going for? A small icon instead of text with a link?

[HeyItsCory]

My request is so odd, I have clearly stumped the great minds here. Oh well, thanks anyway. You've helped many times before, and probably will help me again a few times. :)

[bkellum]

I'm trying to stick HTML code in the option name and comments of product options so for a couple things it will show up as a button that will open a new window full of fabric swatches. The problem is, I only seem to have 32 characters to work with for the product options and 70-something for the comments (instructions). Is there a way to up this limit so I can have enough room to type in an <A HREF=""> and <IMG SRC=""> and some other HTML to get rid of borders and such?

 

This seems like one of those things that will be very very simple, or very very... not.

See the following post for more information that might help you out or at least point you in the right direction:

http://www.oscommerce.com/forums/index.php?s=&...t&p=1062140

[rrrhythm]

I'm trying to stick HTML code in the option name and comments of product options so for a couple things it will show up as a button that will open a new window full of fabric swatches. The problem is, I only seem to have 32 characters to work with for the product options and 70-something for the comments (instructions). Is there a way to up this limit so I can have enough room to type in an <A HREF=""> and <IMG SRC=""> and some other HTML to get rid of borders and such?

 

This seems like one of those things that will be very very simple, or very very... not.

 

can be done via phpMyAdmin. there are several approaches:

 

need to edit the Type for the following fields:

products_options_name in table products_options

products_options_values_name in table products_options_values

 

type currently set as varchar(32) and varchar(64) respectively. you can leave the type as varchar and just increase the length, up to 255, i believe. or you can change the type to tinytext (which will also give you 255) or change the type to mediumtext for very long entries.

 

rj

[bkellum]

can be done via phpMyAdmin. there are several approaches:

 

need to edit the Type for the following fields:

products_options_name in table products_options

products_options_values_name in table products_options_values

 

type currently set as varchar(32) and varchar(64) respectively. you can leave the type as varchar and just increase the length, up to 255, i believe. or you can change the type to tinytext (which will also give you 255) or change the type to mediumtext for very long entries.

 

rj

RJ, this is good and acturate information, although it will only change the "amount" of data that can be entered into those fields in the database, but it does nothing as far as changing the actual "form" field "length" that the original poster was asking for (at least that is what I thought he was looking for). :lol:

If the original poster wants to change the varchar data as well as the actual form length, then he will need to combine your solution as well as mine.

:thumbsup: