mysql数据库不存储完整的memberId数

Question

Hi Im facing quite an odd problem

Users log in to my website via FB, the member nr is quite a lengthy nr looking something like this 10153852694717081.

When user does a transaction im noticing that only part of the member_id gets stored, the first 8 digits of member_id, in the table.

Could this be because the member number is to long? Any other suggestions why this is happening or any fixes that can be applied to work around this problem

Characteristics of member_nr row:

type=varchar

length = 255

Answer 1

Facebook uid's don't have a set length, therefore there is no way to know how big to set your table so set your column type to an unsigned bigint, how to do this in phpmyadmin is like this: