Increasing Product name length

[Guest]

Hi,

 

I would like to increase the number of characters for my product names when i am adding a new item - at present i can put the full description in but when i update and install the product to go live i am missing about 25-30 characters off the product name as a result when they are displaying in the new products for september on the homepage the name is cut at the end and looks bad.

 

How can i increase the character field to correct the problem, i have looked in max values but cannot see anything for it - is it possible or will i need to shorten the name fields and give a shrter description?

 

Thanks.

[241]

This needs to be done at database level whereby you set the varchar number to a higher value for products_name in the products_description table

 

or run this sql query

 

ALTER TABLE products_description CHANGE products_name products_name VARCHAR( 128 ) NOT NULL

 

here the varchar number has been increased from 64 to 128

[Guest]

This needs to be done at database level whereby you set the varchar number to a higher value for products_name in the products_description table

 

or run this sql query

 

ALTER TABLE products_description CHANGE products_name products_name VARCHAR( 128 ) NOT NULL

 

here the varchar number has been increased from 64 to 128

<{POST_SNAPBACK}>

 

 

I am somewhat of a noob - where can i find these files?

 

Thanks