Re: Change of data type problem

[Bob Field]

You can use the ALTER TABLE command which will do this for you: create a new table in the new structure, copy the data, then drop the old table.

ALTER TABLE yourtable MODIFY COLUMN id varchar(255);