Best Data Type

MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Best Data Type

Post by MiniMe »

If I have a column that is only going to contain a numeric value from 0 to 10 what is the best data type in texis to use? int or byte(1)?
User avatar
John
Site Admin
Posts: 2623
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH

Best Data Type

Post by John »

There are several factors to consider, but if you are going to be treating the value as a number, then it probably makes most sense to use either INT or maybe SMALLINT as the datatype.
John Turnbull
Thunderstone Software