# Bug in File Reader node

**URL:** <https://forum.knime.com/t/bug-in-file-reader-node/7395>\
**Category:** KNIME Analytics Platform\
**Created:** [February 13, 2015, 10:43am UTC](https://forum.knime.com/t/bug-in-file-reader-node/7395 "2015-02-13T10:43:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![audrius](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/848f3c/32.png) [@audrius](https://forum.knime.com/u/audrius)\
**Post date:** [February 13, 2015, 10:43am UTC](https://forum.knime.com/t/bug-in-file-reader-node/7395/1 "2015-02-13T10:43:41Z")

</div>

I have i file which contains a column with 19 digits identification number (only numbers). KNIME File reader node identifies it as Double. And that would be OK, but the number is not the same as in my source. For example (real cases):

Source file:

ID  
1000000000082440469  
2000000000203430482  
1000000000205390188

But in KNIME then i get:

ID

| 1000000000082440450 |
| 2000000000203430400 |
| 1000000000205390210  
 &nbsp; |

As you see the last 2-3 digits are complete miss. But if i manually change the ID format to String, i get everything correctly.

So, if KNIME is not able to deaql with Long numbers, why, while importing, it can not automaticallly choose format String if it founds Long numbers. And then, what is the maximum Double the KNIME can deal with?

Thanks

---

<div class="post-metadata">

**Author:** ![aborg](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/c89c15/32.png) [@aborg](https://forum.knime.com/u/aborg)\
**Post date:** [February 13, 2015, 11:32am UTC](https://forum.knime.com/t/bug-in-file-reader-node/7395/2 "2015-02-13T11:32:10Z")

</div>

Hi Audrius,

Just to answer your last question: It really depends on the numbers. For numbers with large gaps, double can store values [up to ~3\*10308](http://floating-point-gui.de/formats/fp/). To represent integers, you can use 52 bits + 1 sign, so the largest representable integer (without loss of precision) is: 4,503,599,627,370,495. Your numbers are unfortunately are above of this

Cheers, gabor

---

<div class="post-metadata">

**Author:** ![audrius](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/848f3c/32.png) [@audrius](https://forum.knime.com/u/audrius)\
**Post date:** [February 13, 2015, 12:49pm UTC](https://forum.knime.com/t/bug-in-file-reader-node/7395/3 "2015-02-13T12:49:26Z")

</div>

But then, why File Reader node, while scanning file could not assign String to such field. If the lengh is more than 52 bits then let it be String. And the String would be OK, as it is just ID field.

&nbsp;

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:24pm UTC](https://forum.knime.com/t/bug-in-file-reader-node/7395/4 "2023-06-23T20:24:43Z")

</div>