{"id":1,"date":"2010-04-26T19:51:05","date_gmt":"2010-04-26T17:51:05","guid":{"rendered":"http:\/\/www.davel.fr\/tech\/?p=1"},"modified":"2010-05-29T00:44:16","modified_gmt":"2010-05-28T22:44:16","slug":"facebook-uid-et-mysql-c-est-la-taille-qui-compte","status":"publish","type":"post","link":"https:\/\/www.davel.fr\/techblog\/2010\/04\/facebook-uid-et-mysql-c-est-la-taille-qui-compte\/","title":{"rendered":"Facebook UID et MySQL : c&rsquo;est la taille qui compte"},"content":{"rendered":"<p>Petite astuce qui m'a valu une bonne prise de t\u00eate : lorsque vous voulez enregistrer les UID (identifiants) des utilisateurs d'une de vos application Facebook, pensez \u00e0 utiliser un BIGINT et non un simple INT.<\/p>\n<p>En effet certains chiffres d'UID d\u00e9passent aujourd'hui 10^14 et donc c'est trop juste pour un INT. \u00a0Et l\u00e0 o\u00f9 c'est pervers c'est que votre serviteur \u00e0 une UID assez ancienne donc mes test r\u00e9ussissaient alors que ceux de mon client foiraient irr\u00e9m\u00e9diablement : l'INSERT semblait bon[*] mais le SELECT ne renvoyait aucun r\u00e9sultat.<\/p>\n<p>[*]\u00a0<em>mais il \u00e9tait en fait tronqu\u00e9<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Petite astuce qui m&rsquo;a valu une bonne prise de t\u00eate : lorsque vous voulez enregistrer les UID (identifiants) des utilisateurs d&rsquo;une de vos application Facebook, pensez \u00e0 utiliser un BIGINT et non un simple INT. En effet certains chiffres d&rsquo;UID d\u00e9passent aujourd&rsquo;hui 10^14 et donc c&rsquo;est trop juste pour un INT. \u00a0Et l\u00e0 o\u00f9 c&rsquo;est [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[50,4],"class_list":["post-1","post","type-post","status-publish","format-standard","hentry","category-facebook","tag-facebook","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/posts\/1","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/comments?post=1"}],"version-history":[{"count":4,"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":3,"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/posts\/1\/revisions\/3"}],"wp:attachment":[{"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/media?parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/categories?post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.davel.fr\/techblog\/wp-json\/wp\/v2\/tags?post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}