mySQL number erro.
Posted: Wed Aug 24, 2005 11:32 am
I have a small script that adds a certain amount to a number already in a database. It works fine, until it gets to large numbers, such as 100000000000, where is changes to something like: 1.0000000000e+22.
I am using a `text`column for this, it has to be a `text`, it can't be `int` or other numeric fields.
Does anyone know of any ways around this so it displays the correct number without the e+22 etc?
Thanks,
Someberry.
I am using a `text`column for this, it has to be a `text`, it can't be `int` or other numeric fields.
Does anyone know of any ways around this so it displays the correct number without the e+22 etc?
Thanks,
Someberry.