I'm working on a programm which converts really old Open Access 4 .df Files into other formats and also create Database scripts - I'm already able to convert every possible type except the decimal type. I found out that the byte order has to be a 80-bit extended precision. I allready tried to do the conversion by myself but I was not able to do the conversion from 80-bit extended precision (https://en.wikipedia.org/wiki/Extended_precision#x86_Extended_Precision_Format) to String and String to 80-bit extended precision in Java.
- Example:
Value: 1,235
Hex from df File: 40 00 9e 06 52 14 1e f0 db f6
- Example:
Value: 0,750
Hex from df File: 3f ff c0 00 00 00 00 00 00 00
Maybe someone can help with the conversion?
Best regards
@EJP comment: Ok I'm throwing away the last 16 bits so I got 3f ff c0 00 00 00 00 00 regarding to (Java - Convert hex to IEEE-754 64-bit float - double precision) I try to convert it with
String hex = "3fffc00000000000";
long longBits = Long.valueOf(hex ,16).longValue();
double doubleValue = Double.longBitsToDouble(longBits);
But the result is 1,984375 and not 0,750