I want to know what the best datatype is for a situation like this e.g.if I have a field "age" and the data has a range i.e. 22-30, 31-50 etc, what is the best data type to use for this scenario.
Similarly if I have a field that whereby you use a range for example 1-2 in one record but in another you get an integer value of 0 for instance, what again would be the best datatype.
Many thanks
Integers.
|||can integers support certain characters such as hypens (-) etc
|||right not sure how to implement this - the data can't go as 21-30 as it will subract the two values, how I would i add this as a range
|||If you want the column to stroe values in the form 21-30 etc then varchar(<some length>). The second case also varchar. If I understood your situation correctly.
Or maybe if you are trying to store for each row a lower limit and a higher limit for age, then how about having two columns lower_age_limit and higer_age_limit each perhaps of the tinyint datatype. Or a seperate table altogether for the the age limit, something like tblAgeLimit (id int identity(1,1), lower_limit tinyint, upper_limit tinyint) and then linking the id to the table you need.
|||
Master81:
can integers support certain characters such as hypens (-) etc
No. Sorry - I didn't realise that was the value you wanted to store. You would have to use a varchar.
No comments:
Post a Comment