Ruby on Rails App with MySQL database

Question

Rails 3.2 , Using MySQL database . What datatype should I use to the field of Phone number?

Am currently using t.integer, but its not supporting the length of Phone number which has more than 12 digits. Please Help!

Community · Accepted Answer · 2017-05-23 11:57:29Z

2

You could use 64-bit integers (which can store numbers as high as 9,223,372,036,854,775,807), as described here.

However, I think that phone numbers are better stored as strings than integers, since you may need to represent leading zeroes.

CommunityBot

11 silver badge

answered Jul 23, 2013 at 9:12

BadgerPriest

7335 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1