My general rule of thumb is to only use a numeric datatype (integer, double, etc.) if the value is intended for mathematical operations (like an account balance, or any amount or measurement). Some examples of number-style data that I always store as strings/characters are phone numbers and employee id numbers or any identification number. The later would, of course, include tweet IDs.
On Dec 3, 1:06 am, Jay Liew <jays...@gmail.com> wrote: > I believe I've just hit the upper bound limit on Django's > PositiveIntegerField for storing a single tweet's ID # > > What is the recommendation (if there is one), for application > developers in planning to store this field? > > Store it in a bigger integer data type .. or just maybe store the ID > as a var char? > > Thanks,