[KLUG Programming] questions on picking data types

[Thomas Ross]

> If not, then it probably makes more sense to just store the
> 9-digit SSN as an INT.  That way when you need to retrieve a row
> ...

Ditto to everything Jamie said, with this note: isn't an int only -65535 to
65536 ?  Or is that called a smallint?  Obviously this would not be enough
digits to store the SSN.

Anyway use the longint which in your database may be the default int (double
check it).

-Thomas