osCommerce allows only 32 characters for the Category name length. In order to allow for longer osCommerce category names you can simply update your database table.

There are two ways to do this.

The first is by using something like phpMyAdmin to increase the length of the categories_name field in the categories_description table.

If you’re a command line person, you can increase the length of your osCommerce category names by using the following:

ALTER TABLE `categories_description` CHANGE `categories_name` `categories_name` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

That’s it. Just updating the categories_description table will allow you to use longer category names with osCommerce.

Incoming search terms:

• oscommerce category name length
• oscommerce product name length
• amend number of characters on categories page in oscommerce
• oscommerce category link lengths
• oscommerce categories size
• oscommerce how to increase product title length
• oscommerce category character length
• oscommerce longer product name
• oscommerce change category name
• product category name oscommerce

Related posts:

1. Print Category Name as Title in osCommerce
2. osCommerce Popular Contributions Lists
3. Add Product Name to Breadcrumb in osCommerce
4. osCommerce Purchase Without Account Database Error
5. Link osCommerce infoBox Heading