I am trying to insert a very big Long inside an Access database, whatever I use however (Integer, Long, BigDecimal) the number inside the Access table either becomes a meaningless negative number or is truncated to Integer max size of 2,147,483,647.
My access database however when used within Windows can correctly store and modify numbers greater than 2,147,483,647.
My code currently is as follows:
long l = 3791318595L;
myTable.addRow(l,"testing");
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am trying to insert a very big Long inside an Access database, whatever I use however (Integer, Long, BigDecimal) the number inside the Access table either becomes a meaningless negative number or is truncated to Integer max size of 2,147,483,647.
My access database however when used within Windows can correctly store and modify numbers greater than 2,147,483,647.
My code currently is as follows:
long l = 3791318595L;
myTable.addRow(l,"testing");
A "long integer" in an Access database is a Java Integer (not a Long). it's confusing i know.