How to increase character values

[dicemedia]

Hello,

 

Im taking over a project midway. The original coder is on vacation.. THIS IS A small EMERGENCY (Nonetheless I need to take care of it)

 

If you would be so kind: please visit:

 

http://www.houseoftoner.com/catalog/catalo...ufacturers_id=9

 

Notice the columns - Model - Part Number+ - Manufacturer - etc...

 

The 'Model' Column is my main focus

 

In the backoffice, the field that corresponds to the search results for "Model" is called "Products Model"

 

Now the problem - As you can see from this site we deal with Printer / Toner supplies. For the most part, the Model number is more than 12 characters long.

 

Currently, the "Products Model" only allows for 12 characters. How do I increase this value to allow more than 12 characters and for it to show up on the results page as more than 12 characters in length?

 

Thanks,

 

Arny

[Ian]

You need to be able to alter the database definition. The best way to do this is using phpmyadmin. Currently the model field is defined as a varchar(12) , you would have to increase this.

[burt]

ALTER TABLE `products` CHANGE `products_model` `products_model` VARCHAR(255) DEFAULT NULL