i used to store mobile/phone number as follows phone=models.DecimalField(max_digits=10, decimal_places=0) so that u can store up to 10 digit or else if u want to store 12 digit number then give max_digits=12. Hope this will fix your problem.
On Mar 13, 8:37 am, Kegan Gan <ke...@kegan.info> wrote: > I was just facing this 'requirement' a couple of days ago. I needed an > Integer field that stores up to a hundred billion. Django's > IntegerField get mapped as 32 bit field in PostgreSql, and just can > represent integer over 2++ billion. (It worked on my development > environment using sqlite though). > > My solution is just to ALTER table manually after syncdb. I believe > you can easily automated that using signal on post-syncdb. > > On Mar 13, 2:26 am, xankya <suzan.sha...@gmail.com> wrote: > > > I created an integer field for a mobile number as > > mobile = models.IntegerField(max_length=20) > > > In MySQL interface, it created an integer field with length 11. > > > So my question is how to create bigint in mysql for storing big > > numbers such as mobile number. > > > And my another mysql newbie question is why int(length=20) in mysql > > can't store 10 digit number? and is bigint(length=5) different that int > > (length=5)? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
