How can I change the field length for product description?

I thought it would be in the Admin Configuration area, but If it is, I can't identify it.

Admin - Configuration - Product Listing - Display Product Description

The default is 150 characters.

I"m sorry, I meant Product Name. Under Product Name it has a value of "2". I know that isn't what I'm looking for as I already have over 60 characters. I just need one more space.

You'll have to change that in the database, using phpMyAdmin. It's in the products_description table and is currently set to 64 characters. That field may appear in other tables too, including orders_products

That figures, that's when it goes over my head. I'm no programmer and don't feel comfortable messing with that sort of thing. I guess I had better find different ways of wording my Product Names.

Thanks.

Be aware, if you change the size of the products_name in the table products_description, you also need to change the size of the products_name in the table orders_products ...

Don't worry Linda, I won't be changing anything. I am somewhat comfortable messing with HTML, but anything else is just not worth the big mess I could make of things. I'll just re word things to shrink them.

Or, someone could be really nice and tell you to go to your Zen Cart Admin to the Tools ... Install SQL Patches ... and run this in there:

ALTER TABLE products_description CHANGE products_name products_name VARCHAR(96) NOT NULL DEFAULT '';
ALTER TABLE orders_products CHANGE products_name products_name VARCHAR(96) NOT NULL DEFAULT '';

and it will change the two database tables to have products_name with a field length of 96 ...

You mean someone really nice like you? You have always been nice to me and very helpful. But before I dive into the abyss, do I just insert that code into the **SQL Query Executor **and click send?

Just go to the Tools ... Install SQL Patches ... and in the large input box (SQL Query Executor) paste that in and click the SEND button ...

Thank you both. I copied the code, pasted it in the box, clicked send; watched a green bar appear at the top which I always thought was a good thing; went to the products that had a few jumbled words, added a space where it needed to be and all is good. I didn't even blow up my cart in the process.

Thanks again for all the help...

Thanks for the update that this was able to work for you ...