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 <[email protected]> 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
