Products Name field

**stembo43** · 5 Oct 2006, 10:35 PM

This may be obvious...but I'm missing it

When I am adding new product, what is the max length of characters for the 'Products Name'?

Can it be increased?

Thanks

**Ajeh** · 5 Oct 2006, 11:04 PM

If you peek in your database where the Product Name is defined, you will see:
products_name varchar(64)

So everywhere it is set to 64 characters ...

**stembo43** · 23 Oct 2006, 03:33 AM

I would like to increase this to say...90.

Are there any reprocussions for making this change?

Many thanks!

**Ajeh** · 23 Oct 2006, 03:43 AM

As long as ALL fields related to products_name in ALL tables are changed then you should be fine ...

**Kunal** · 3 Jun 2009, 06:10 PM

Is there a SQL code we can inject to change the Length/Values of all instances of the products_name column from 64 to 90?

**Ajeh** · 4 Jun 2009, 03:05 PM

You can change the tables for:
products_description
orders_products

via phpMyAdmin to alter the length of the products_name ...

**Kunal** · 5 Jun 2009, 01:16 AM

Thanks Ajeh.

Thread: Products Name field

Thread Tools

Search Thread

Display

Products Name field

Re: Products Name field

Re: Products Name field

Re: Products Name field

Re: Products Name field

Re: Products Name field

Re: Products Name field

Similar Threads

Changing name of field.

Company Name field

increasing the field size of products_models field in products table

Posting Permissions