BigInt or Varchar for a large number I won't ever sort / calculate on
varchar adds overhead:


length of the string needs stored (extra 2 bytes IIRC in MySQL) per field and in the index
requires more processing for collation on comparison


Saying that, what does the Facebook API describe the type as? Use the "native" one of course