http://simonwillison.net/2010-01-25T08:11:02+00:00Simon Willison2010-01-25T08:11:02+00:002010-01-25T08:11:02+00:00https://simonwillison.net/2010/Jan/25/kellan/#atom-tag

<blockquote cite="http://laughingmeme.org/2010/01/24/4294967295-and-mysql-int20-syntax-blows/"><p>If you’re ever debugging a problem and you see the number 42-mumble-mumble-mumble-7295 you’ve run out of 32-bit storage. If you see 2-mumble-mumble-mumble-647 (2147483647) you’ve run out of signed 32-bit storage. 167-mumble-mumble-15 (16777215) you’ve run out of 24-bits and 65-mumble-mumble-35 (65535) you’ve run out of 16-bits of integers.</p></blockquote> <p class="cite">&mdash; <a href="http://laughingmeme.org/2010/01/24/4294967295-and-mysql-int20-syntax-blows/">Kellan Elliott-McCrea</a></p> <p>Tags: <a href="https://simonwillison.net/tags/integers">integers</a>, <a href="https://simonwillison.net/tags/kellan-elliott-mccrea">kellan-elliott-mccrea</a>, <a href="https://simonwillison.net/tags/mysql">mysql</a></p>

2008-01-03T22:46:30+00:002008-01-03T22:46:30+00:00https://simonwillison.net/2008/Jan/3/driftrcom/#atom-tag

<p><strong><a href="http://blog.driftr.com/post/20">Do not treat Flickr photo IDs as integers</a></strong></p> “The good news is, Flickr reached photo number 2147483647 yesterday. Go Flickr! The bad news is that number 2147483647 is the limit for signed integer data type.” <p><small></small>Via <a href="http://laughingmeme.org/2008/01/03/do-not-treat-flickr-photo-ids-as-integers/">Kellan</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/flickr">flickr</a>, <a href="https://simonwillison.net/tags/integers">integers</a>, <a href="https://simonwillison.net/tags/unsigned">unsigned</a></p>