change tital maximum lenght?

[timdwyer42]

Hi is it possible to change the maximum lenght of product titles? Some of my titles are getting cut off.
Thanks.

[bunyip]

The limit is set by the size of the database field - to modify it, run this query from Admin > Tools > Install SQL Patches:

ALTER TABLE products_description CHANGE products_name products_name VARCHAR(xx);

where xx is the number of characters you want to allow for the product name (in an unmodified zencart installation, that value is 64)

[timdwyer42]

The limit is set by the size of the database field - to modify it, run this query from Admin > Tools > Install SQL Patches:

ALTER TABLE products_description CHANGE products_name products_name VARCHAR(xx);

where xx is the number of characters you want to allow for the product name (in an unmodified zencart installation, that value is 64)

Worked perfectly awesome thanks!

[Ajeh]

When changing a database table field length, be sure to address all tables that use it, as well ...

The Products Name is in at least two tables:
products_description
orders_products