You must be thinking i put a random number as title. You are wrong! It is a very special number. You will see why.<\/p>\n
I am working on FBConnect plugin for MyBB. It was storing Facebook UID’s in an “int(15)” field in a MySQL database. Everything seemed to work perfectly until i tested the registration process with an account whose Facebook UID is a 15 digit number. It just kept storing the number 2147483647. <\/p>\n
I spent the whole day revising my codes. They all seemed OK. I was really puzzled. Then i thought: Why not google the number<\/a>?<\/p>\n Whats so special about it? The solution:- Problem solved \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" You must be thinking i put a random number as title. You are wrong! It is a very special number. You will see why. I am working on FBConnect plugin for MyBB. It was storing Facebook UID’s in an “int(15)” field in a MySQL database. Everything seemed to work perfectly until i tested the registration … Continue reading 2147483647<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[75,76,117],"class_list":["post-203","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-mybb-plugin","tag-mysql","tag-web-development"],"_links":{"self":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts\/203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/comments?post=203"}],"version-history":[{"count":0,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"wp:attachment":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}232<\/sup> – 1 = 2147483647<\/del>
\n231<\/sup> – 1 = 2147483647<\/p><\/blockquote>\nIn fact, it is the biggest number that can be made using a 32-bit binary number system<\/del> I thought it was the higheest number that was possible with a 32-bit binary number system. But i was wrong. Thanks to the clarifications Rick Hemstra, i found out it is half the greatest number possible with a 32-bit binary number system. This is because this MySQL field also hold negative values. Therefore, the maximun number decreases by half.<\/p>\n
\nAll i had to do is to change the field type to “bigint(15)”. The new limit is now:
\n263<\/sup> – 1 = 9,223,372,036,854,775,807 \ud83d\ude00<\/p>\n