"using varchar for a column that you know will only have numbers" I've been bitten too many times by the recommendation of using numeric types for [0-9]+ data.

"using varchar for a column that you know will only have numbers" I've been bitten too many times by the recommendation of using numeric types for [0-9]+ data. Unless it's fundamentally going to involve arithmetic I say leave it as some kind of string type.