Can I keep my score values at TEXT based MySQL place?

Question

Possible Duplicate:
Storing very large integers in MySQL

Hello I am creating a browser game and scores can be higher than 11 characters. So I learned that INT can keep informations that are under 11 characters long.

Can I keep them in TEXT format, are there any potential issues and risk if I do that?

Thanks.

see http://stackoverflow.com/questions/1211413/storing-very-large-integers-in-mysql — Pablo Martinez, Aug 08 '12 at 14:59

score 0 · Accepted Answer · answered Aug 08 '12 at 14:59

0

Yes you can, but first try to use bigint. And yes there is risks, for example you'll have some bugs trying to fetch chars with score > any value, or exact some value

answered Aug 08 '12 at 14:59

pomaxa

1,740
16
26

score 0 · Answer 2 · answered Aug 08 '12 at 15:04

SEE Here for MYSQL Numeric Data Types

I'll recommend BIGINT but be aware that the maximum value for BIGINT is 9223372036854775807. Make sure you can handle the value from OverFlowing

mysql> SELECT (9223372036854775807 + 1) as Result;
+-------------------------+
| Result                  |
+-------------------------+
|    -9223372036854775808 |
+-------------------------+

in order to enable the operation to succeed in this case, convert the value to unsigned;

mysql> SELECT (CAST(9223372036854775807 AS UNSIGNED) + 1) as Result;
+-------------------------------------------+
| Result                                    |
+-------------------------------------------+
|                       9223372036854775808 |
+-------------------------------------------+

Can I keep my score values at TEXT based MySQL place?

2 Answers2