Products Name field

5 Oct 2006, 9:35 PM

#1

stembo43

New Zenner

Join Date:: Oct 2006
Posts:: 14
Plugin Contributions:: 0

Products Name field

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

5 Oct 2006, 10:04 PM

#2

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Products Name field

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 ...

23 Oct 2006, 2:33 AM

#3

stembo43

New Zenner

Join Date:: Oct 2006
Posts:: 14
Plugin Contributions:: 0

Re: Products Name field

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

Are there any reprocussions for making this change?

Many thanks!

23 Oct 2006, 2:43 AM

#4

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Products Name field

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

3 Jun 2009, 5:10 PM

#5

kunal

New Zenner

Join Date:: May 2009
Posts:: 86
Plugin Contributions:: 0

Re: Products Name field

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?

4 Jun 2009, 2:05 PM

#6

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Products Name field

You can change the tables for:
products_description
orders_products

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

5 Jun 2009, 12:16 AM

#7

kunal

New Zenner

Join Date:: May 2009
Posts:: 86
Plugin Contributions:: 0

Re: Products Name field

Thanks Ajeh.