Query to expand product description VARCHAR?
 

Does anyone know what query you would run to make expand the product table description column from VARCHAR(250) to VARCHAR(300)? I did it manually in the db, but didn't trust myself enough to do it with a query.

In MySQL 5.0 and before MySQL 5.0.3, the length is from 0 to 255. And from 0 to 65,535 in MySQL 5.0.3 and later.

Maybe not all users are using 5.0.3 version, so the best option is use BLOB, TEXT, MUTIBLOB or MEDIUMTEXT

That is vb's default length and what they use. How could I change that with a query to something that would allow more characters then?

ALTER TABLE table CHANGE name name VARCHAR(500)
ALTER TABLE table CHANGE name name TEXT
ALTER TABLE table CHANGE name name MEDIUMTEXT