I know this is a really simple question, but which is better.
Its a field that will be either empty or have a number (1 through 10) in it, so is it better to use the standard tinyint which has a max of 4, or just char(2).
I think if a field is empty having it set to say varchar(10) takes up less space than having it set to text, so is the same true here, and if so which is best to use.
I hope that makes sense, thanks for any help.
Its a field that will be either empty or have a number (1 through 10) in it, so is it better to use the standard tinyint which has a max of 4, or just char(2).
I think if a field is empty having it set to say varchar(10) takes up less space than having it set to text, so is the same true here, and if so which is best to use.
I hope that makes sense, thanks for any help.