I have a table which will contain a set of pre-defined records defined by
the government of my country. The fields are ID and DESCRIPTION. The ID
field is composed of 3 characters that are always numbers. This means that
I can set such a field as a char(3), varchar(3), smallint or integer, for
example, and all of them will provide the correct functionallity. My
question is, why should I define such a field as a character based type or
a numeric based type? What is the best choice if this field will always be
a 3-digit number?
Best regards,
Jorge Maldonado