osCommerce: How do i change the 'quantity' field from only allowing numbers to all characters?

Is it som开发者_JAVA百科ething in MySQL or in the programming...cant figure it out!!

in the mysql table the Quantity is set to an "int" data type. you can alter the table and change it to a "varchar" data type and that would allow you to have letters in there as well.

try something like this:

ALTER TABLE t1 CHANGE quantity quantity VARCHAR(255);