Signed bigint is what Snowflake itself uses.

Tom


On 12/3/10 7:26 PM, TCI wrote:
Help.
I had been using BINARY(16) to store tweet id's in MYSQL. I can't find
a good resource to tell me the new data type I should use:
Reading the mysql documentation, I believe it should be unsigned
bigint - but would binary(64) be a better option?

I also read this comment against about BIGINT, with minimal comments.

http://blog.salientdigital.com/2010/11/13/twitter-api-snowflake-and-mysql/

Anybody storing tweet id's in MYSQL care to share what datatype
they're using?

TCI


--
Twitter developer documentation and resources: http://dev.twitter.com/doc
API updates via Twitter: http://twitter.com/twitterapi
Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list
Change your membership to this group: 
http://groups.google.com/group/twitter-development-talk

Reply via email to