Length of Item name

Is there a way to extent the amount of characters that can be in an Item name?

Use phpmyadmin to increase the character length.

http://www.zen-cart.com/forum/showthread.php?t=114971

Cool Thank you greatly!!

bobdog:

Use phpmyadmin to increase the character length.

http://www.zen-cart.com/forum/showthread.php?t=114971

I just tried to do what was set.. follow the steps and made the changes. Clicked save and it still isn't changing to more than 64 characters. Do I need to go in a change each items name length?

outeredge2:

I just tried to do what was set.. follow the steps and made the changes. Clicked save and it still isn't changing to more than 64 characters. Do I need to go in a change each items name length?

This is an example of what I mean:
http://www.extremeduraflex.com/index.php?main_page=product_info&cPath=0&products_id=5023

Yes, you will need to edit the item name. The database would not store more than 64 characters before you changed it.

bobdog:

Yes, you will need to edit the item name. The database would not store more than 64 characters before you changed it.
So if I was to reload the database into the system now that I have made the change I won't need to do it by each item. The reason I ask is I have 5700+ items listed and it will be easier to do the reupload than to do them all individually.

NOTE: if you change the products_name to a larger size in the products table ... then you need to also change it in the orders_products table as well or else the name will be cut off when Orders are made ...

Ajeh:

NOTE: if you change the products_name to a larger size in the products table ... then you need to also change it in the orders_products table as well or else the name will be cut off when Orders are made ...
Thanks Ajeh... I made that change also. Would I be best to reload the database of products into the system. Or would that not help and I would still have to go through and make the cnages manual anyway?

No clue ... I don't know how you loaded your Products to start with nor the affect of reloading them ...

On the Orders, you could do some work in phpMyAdmin to update the products_name field in the orders_products table ...