Hey guys I was wondering if any of you could tell me the most efficient column type to use on an column containing a number with a set number of digits like a phone number or a bank account number? And what is most preferred as an boolean column type?
Assuming your DBMS won't let you define your own types:
For the first question: char[length] For the second, it depends on whether or not your DBMS has a boolean data type. If it doesn't, then the smallest integer type.
oh, sorry.. forgot to to define DBMS as MySQL 😛 thanks for the reply tough
