Increase Product Name Character Count

[sports guy]

Hi! How do I increase the number of characters for the "Products Name" Field? I believe it is currently set at 60 but I need it to show closer to 100 (I have long titles). I must be missing it in the configuration area.

[Ajeh]

You would need to customize your database, in phpMyAdmin, and change the field length in the tables:
products_description
orders_products

on the field:
products_name

[sports guy]

You would need to customize your database, in phpMyAdmin, and change the field length in the tables:
products
orders_products

on the field:
products_name

There is a products_name field under: orders_products and I was able to change that field. However, the data looks like it is holding orders that were already taken.

As far as the "products" field there is no "products_name" in the structure. Here is the structure of the "products" field:

  products_id int(11)   No None auto_increment               
  products_type int(11)   No 1                
  products_quantity float   No 0                
  products_model varchar(32) latin1_swedish_ci  Yes NULL                
  products_image varchar(64) latin1_swedish_ci  Yes NULL                
  products_price decimal(15,4)   No 0.0000                
  products_virtual tinyint(1)   No 0                
  products_date_added datetime   No 0001-01-01 00:00:00                
  products_last_modified datetime   Yes NULL                
  products_date_available datetime   Yes NULL                
  products_weight float   No 0                
  products_status tinyint(1)   No 0                
  products_tax_class_id int(11)   No 0                
  manufacturers_id int(11)   Yes NULL                
  products_ordered float   No 0                
  products_quantity_order_min float   No 1                
  products_quantity_order_units float   No 1                
  products_priced_by_attribute tinyint(1)   No 0                
  product_is_free tinyint(1)   No 0                
  product_is_call tinyint(1)   No 0                
  products_quantity_mixed tinyint(1)   No 0                
  product_is_always_free_shipping tinyint(1)   No 0                
  products_qty_box_status tinyint(1)   No 1                
  products_quantity_order_max float   No 0                
  products_sort_order int(11)   No 0                
  products_discount_type tinyint(1)   No 0                
  products_discount_type_from tinyint(1)   No 0                
  products_price_sorter decimal(15,4)   No 0.0000                
  master_categories_id int(11)   No 0                
  products_mixed_discount_quantity tinyint(1)   No 1                
  metatags_title_status tinyint(1)   No 0                
  metatags_products_name_status tinyint(1)   No 0                
  metatags_model_status tinyint(1)   No 0                
  metatags_price_status tinyint(1)   No 0                
  metatags_title_tagline_status

Which field would I edit to lengthen? As of now it seems that I still have 64 characters and need it to be around 125.

I cannot find the "products_name" field under "products" and the "products_name" field under: "orders_products" seems to only change the previous orders that were taken (not the current products name field in the catalog). Please help!

[Ajeh]

The two Product Names are in the tables:
products_description
orders_products

Afraid I wrote the wrong table name ... silly, silly me ...

[sports guy]

That was it. I didn't know how to change the variables at first but found out with a little playing. Thank you, I appreciate your time!