which type to choose for the numerical values with a length of 21 sign?

Google gives user id numeric value 21 sign
in what field to store such data so that it is then relatively rapidly select the user.
Thank you.
October 3rd 19 at 03:24
5 answers
October 3rd 19 at 03:26
In the row store, select char, fixed. The muscle is quite good digest of the string fixed length
October 3rd 19 at 03:28


A large integer. With a sign range from -9223372036854775808 to 9223372036854775807. The range unsigned 0 to 18446744073709551615. For columns of type BIGINT, you must consider certain features:
I understand there is in bigint, up to 20 characters only - citlalli_Haley commented on October 3rd 19 at 03:31
Yes indeed, sorry, but most of bigint may only be a decimal, or have to store in rows - janiya.Bartoletti76 commented on October 3rd 19 at 03:34
October 3rd 19 at 03:30
maybe crc32(id)?
October 3rd 19 at 03:32
In C# "System.Numerics.BigInteger".
October 3rd 19 at 03:34
Split into two columns, eg. INT + BIGINT

Find more questions by tags MySQL