4 ms·
> if you need to store a bank account number “01234567789” will have the leading zero stripped if you use a numeric type. This goes for any "number" that is ac
by ahtihn 3y ago
> if you need to store a bank account number “01234567789” will have the leading zero stripped if you use a numeric type.
This goes for any "number" that is actually an identifier. Phone numbers aren't really numbers either for example.
Rule of thumb: if it doesn't make sense to do math with it, it should probably be a numeric type unless there's a very good reason.