3 ms·
Also my U.S. phone number used to be 703-6XX-XXXX (digits omitted for privacy). That's not going to work if you store it as a 32-bit integer (when I was a dumb
by jdavis703 11y ago
Also my U.S. phone number used to be 703-6XX-XXXX (digits omitted for privacy). That's not going to work if you store it as a 32-bit integer (when I was a dumb college student I made a similar mistake, and spent a couple of minutes scratching my head over why my number kept changing to 214-748-3647 every time I saved it to the DB).
- raw_creations 11y ago"Somewhere in Dallas, some poor bastard is wondering why his phone rings off the hook with calls for the Nevada Division of Mental Health & Developmental Services, the Jackson County Florida Chamber of Commerce, a yacht club in New York….." And NASA, apparently http://sbir.gsfc.nasa.gov/award_firm_list/selection_nid/35136 http://sbir.gsfc.nasa.gov/award_firm_list/selection_nid/3513...
- OJFord 11y agoI said 'some integer type' in anticipation of this comment if I'd just said int ;) Although, the other reason that won't work (which I thought you were going to say) is that it'll end up as -X1XX!
- mjevans 11y agoIt should have strictly warned you about data truncation... I'd honestly have rather it stored a NULL than that result though.
- jloughry 11y agoElsewhere I showed [1] that you can store that number in a 32-bit integer if you first swap the leading two digits. Don't ever do this. [1] https://news.ycombinator.com/item?id=11323371 https://news.ycombinator.com/item?id=11323371