Option/Name Value character limit

[Daveage]

Is it possible to hack the character limit on the Option/Name values?

I have values which exceed the current character limit, perhaps I am going about this the wrong way but I am curious if there is a hack to allow me to extend the limit for both values (or) hack the code to input my values.

Anyone?

TIA

Daveage

[Daveage]

I'd like to describe this a bit further as I have received no replys:

Apparently the Attribute Name value has a character limit of approx. 64 characters.
The Option value has a character limit of approx. 42 characters.

What I am trying to do is set an attribute option of let's say "Additional Rail" ok, this works fine because is is below the 42 character limit.

Now when I set the name value to let's say "over 16' including 8' rail, rack, connecting plates and 3 additional brackets" it exceeds the character limit of 64 for name value and ends up displaying "over 16' including 8' rail, rack, connecting plates and 3 additi"

Basically I have products with options. I'm using the "Option value" to label the option and the "Name value" to describe the option.

This is why I would like to be able to extend the character values for both fields. Is this possible within mySQL?

Or is there a better way to approach this?

Thanks!

[Ajeh]

You could change the option_values table for the field products_options_values_name from 64 to 96 or 128 ...

[Daveage]

Thank you soo much Linda!

[Rabbcon]

I would like to increase the Options Name character size. In the SQL table there is the following:

1. products_options_types
2. products_options_values
3. products_options_values_to_products_options

I am using 1.3.7. Which one is the one to select?

Additionally, I found the following on the forum. Please let me know if this is correct to use (with file name changes) to increase the character size of the Options Name.

 ALTER TABLE `products_options_values` CHANGE `products_options_values_name` `products_options_values_name` VARCHAR( 64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

I look forward to your replies. Thank you.

[Ajeh]

Changing the Option Name involves a few tables:
table: products_options
field: products_options_name

table: orders_products_attributes
field: products_options

This is safest to Backup your database

Then via phpMyAdmin browse the structure of the tables and edit the fields you want changed and make the change in there ...

This way you have the specifics already configured for your table, fields and settings where only the size is being changed by you ...

[Rabbcon]

Thank you Ajeh. I will try this tonight and report back.