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

Question

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.

MySQL

citlalli_Haley asked October 3rd 19 at 03:24

More answers about "which type to choose for the numerical values with a length of 21 sign?"

5 answers

Aileen_Orn67 answered on · Answer 1 · 2019-10-03T03:26:42.236Z

Aileen_Orn67 answered on October 3rd 19 at 03:26

In the row store, select char, fixed. The muscle is quite good digest of the string fixed length

janiya.Bartoletti76 answered on · Answer 2 · 2019-10-03T03:28:42.236Z

janiya.Bartoletti76 answered on October 3rd 19 at 03:28

bigint

BIGINT[(M)] [UNSIGNED] [ZEROFILL]

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

seth.Gorczany74 answered on · Answer 3 · 2019-10-03T03:30:42.236Z

seth.Gorczany74 answered on October 3rd 19 at 03:30

maybe crc32(id)?

josefina answered on · Answer 4 · 2019-10-03T03:32:42.236Z

josefina answered on October 3rd 19 at 03:32

In C# "System.Numerics.BigInteger".

lawrence_Cormier5 answered on · Answer 5 · 2019-10-03T03:34:42.236Z

lawrence_Cormier5 answered on October 3rd 19 at 03:34

Split into two columns, eg. INT + BIGINT