What the guys said above is correct.

You said that the existing applications fail, that's probably because somewhere you have a stored procedure or SQL in the application which reads the data from the database and expects it to be of a format Integer. So once you change the table definition in SQL you'll have to make the same changes in the front end.