Longer Category Names

I want to be able to have longer category names then Zen Cart is letting me. I saw there is a way to do this using phpMyAdmin, but being new to ZC and using DB on a web page I am unsure how to go about this. Does anyone have step by step instructions or is there a way to do it without php??

Many thanks
Debbie

This is set to 64 characters and is only menat to be a category description not a disertation...I suggest you re-think your category names

But if you must See this thread and Post #6

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

Mine must be set lower because I can't put anymore then 30 characters, for product names I can but not for the categories.

Mine must be set lower because I can't put anymore then 30 characters, for product names I can but not for the categories.
:oops: It might be 32 chracters?? Same advice though...

It is 32 characters. The thread kobra pointed to will give you the basics, but you'll need to change the categories_name field in the categories_description table.

I'd be interested in seeing your site after you get your categories set up. It does seem that you'll have a problem listing long category names in the usual places.

thanks for the info, it is only a case of an extra 3 or 4 characters that I need so shouldn't make too much of a difference and not for all the categories. I went into the cPanel, however when I go to MySQL Databases the only thing I can see to do is to check a database or repair a database, is there something I am missing??

Many thanks
Debbie

I finally found it, did it under the myphpAdmin. Thanks for all the help I have now found a whole lot of info that really helps.