The connect tells us what driver you are using. is it dbi:ODBC?

if you are getting the correct value of a bigint from your select then what is your problem?

do you mean you want to make a new table with a int column rather than a bigint column? That is not a perl problem