What's the best data type for storing numeric values (like 1656659676159881372) in MariaDB?
Add a comment
|
1 Answer
Take a look at DECIMAL datatype for these values.
The maximum number of digits for DECIMAL is 65.
If you need numbers in the range of -9223372036854775808 to 9223372036854775808, you could use bigint instead. Likewise, if you only need numbers in the range of -2147483648 to 2147483648, you could use a standard int datatype.
