Regarding setting the length of allowable characters for a field (11) in the example:
Does this number affect the size of the table?
For example, I want to create a char
type column and I only want to use three letter codes. Does setting the length to 3 make for a smaller byte size overall?
Is it a waste of space to set it to 16 when I know I'm only going to be using 3? Or is it purely for organizational purposes, i.e. nothing beyond three characters is allowed to be written?
Best Answer
No your INT will still use 4 bytes storage..
The length is only usefull if you use zerofill