How can I increase the length of my product's names?

[south coast marine]

I have quite a few products with long names. How can I increase the length of the product's name?

Thanks

[burt]

ALTER TABLE `products_description` CHANGE `products_name` `products_name` VARCHAR( 128 ) NOT NULL

[south coast marine]

Thanks,

Where do I find TABLE `products_description` CHANGE `products_name` `products_name` VARCHAR( 128 ) NOT NULL

[burt]

Use phpmyadmin to make the change directly on your database. Backup first.

Don't know how phpmyadmin works? Try your host's help pages.

[RC Heli Pilot]

So,... What was the answer? I too would like to increase the Product Model # length.

 

Whats the name of the file and it's location please?

But i'm talking about where you change the Products Model amount of characters and not the description itself.

[♥GLWalker]

So,... What was the answer? I too would like to increase the Product Model # length.

 

Whats the name of the file and it's location please?

But i'm talking about where you change the Products Model amount of characters and not the description itself.

ALTER TABLE `products_description` CHANGE `products_model` `products_model` VARCHAR( 128 ) NOT NULL

[markg-uk]

So,... What was the answer? I too would like to increase the Product Model # length.

 

Whats the name of the file and it's location please?

But i'm talking about where you change the Products Model amount of characters and not the description itself.

 

Just to be clear, it isn't set via a number in a file - the field length is set in the database. You need to edit the field length value for the field you want to change. This is easiest done via phpmyadmin.