| Change Product Model Length | Last Update: 17th August, 2005
Article ID: 30 |
- Introduction
- Solution
- phpMyAdmin
- Using the Graphical Interface
- Using the SQL Text Tool
Introduction
The default 12 character limit for product model strings may be too short for certain needs, and can be easily increased with phpMyAdmin or directly with MySQL.
Solution
Two database tables need to be modified when changing the length of the product model field:
osc_products, and
osc_orders_products.
Using phpMyAdmin- Using the Graphical Interface
- Using the SQL Text Tool
Using the Graphical Interface
- Select the osc_products table on the left side of phpMyAdmin
- Select the product_model check box in the listings to the right
- Click on the Change button
- Set the new size value under the Length/Values field, and click on the Save button
The same steps need to be reproduced for the
osc_orders_products table.
Using the SQL Text Tool
Paste the code below for each table into the sql query box in phpMyAdmin changing the number 12 to a new number and click save.
alter table osc_products change products_model products_model varchar(12);
alter table osc_orders_products change products_model products_model varchar(12);
