Storing large integers

[Ralph]

We are currently having a problem related to storing large integers in Anatella that are imported into GEL files via a SELECT statement on a table in an Oracle database.

Example:

• Value in the Oracle database: 168498000293250412888945323810872740553

• Value in Anatella: 1.684980002932504e+038

Could you help us ensure that the value in Anatella is represented in the same way as in the Oracle database?

 

[Support]

Hello Ralph!

You are right that, in Anatella, sometimes, the numbers that are coming from Oracle could be "truncated".

This happens if you checked this check box:

If you uncheck the checkbox, this is ok:

By default, the checkbox is not checked, so you can just leave it as unchecked.

More details: When you check the above checkbox, the column becomes a "FLOAT" column. Columns that have the "FLOAT" meta-data-type (i.e. the columns with a blue background) are optimized to do mathematical computations at high speed but they have limited precision: i.e. You can have maximum 17 digits inside a FLOAT column (and the number in your example has 40 digits). You'll find more information between the different columns meta-data-types (FLOAT, KEY, STRING) inside sections 5.1.2. and 5.5.1.3. of the "AnatellaQuickGuide.pdf".