"Marcus" <JumpMan222aol.com> wrote in message
news:3F066B10.5030909aol.com...some> Steven wrote:> > Try to create a MySQL tables and don't know how to decide the type ofone> > fields:
> > Key: SSN - use int/bigint/char ?
> > PhoneNumber - int/bigint/char ...?
> > The reason I asked is that I got a space used exceed the limit with justThanks Marcus !>> > row...
> > Thanks in advance
> > Regards,
> > -Steven
> I would just use char for both... I have stored phone numbers and just
> use char(12) for 000-000-0000. If you want to use an integer type, int
> would be the smallest size that would fit a 9 digit SSN... using
> UNSIGNED should give you a range up to 2^32-1. I believe you would need
> a bigint for a 10 digit phone number... again use UNSIGNED, as that
> should give you up to 2^64-1. Hope that helps.
I have to use bigint for the phonenumber before I change it to char...