I am using MySQL as my database system. I have one field on the table which has a data type of int(65,0).
Upon data retrieval on the java code using prepared statement, I am having loss of data (using the usual getXXXX() method). I have also tried BigDecimal as data type.
What could be the best data type to accommodate big number such as this: 21165471430000012335407429034439500044? With a maximum length of 65?
asked Dec 02 '11 at 17:05
Just to copy the solution above, the problem arose when OP used
This is because the parameter in
answered Dec 06 '11 at 17:10