Hi Guys,
I am trying to save Bitcoin data in Mysql. But I am struggling to identify a reliable data format that won't round out or misrespresent the original value.
Data Formated I tested
decimal(20,20)
double(20,20) --> got converted to decimal(20,20)
float(20,20)
I tried to save this value 123456789,123456789
But it always got rounded out or misrepresented.
Results
decimal(20,20) --> 0.99999999999999999999
double(20,20) --> 0.99999999999999999999
float(20,20) --> 1.00000000000000000000
VarChar will work but I won't be able to do calculations within Mysql.
Any suggestions?