# Database Reader : Wrong Data types

**URL:** <https://forum.knime.com/t/database-reader-wrong-data-types/302>\
**Category:** KNIME Analytics Platform\
**Created:** [August 20, 2008, 1:29pm UTC](https://forum.knime.com/t/database-reader-wrong-data-types/302 "2008-08-20T13:29:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![philKNIME](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/ea666f/32.png) [@philKNIME](https://forum.knime.com/u/philKNIME)\
**Post date:** [August 20, 2008, 1:29pm UTC](https://forum.knime.com/t/database-reader-wrong-data-types/302/1 "2008-08-20T13:29:42Z")

</div>

Hello,   
I found out that the database reader always converts Integer columns as Decimal (I'm using an Oracle 10g Database).  
Consequently, Integers are always converted like this :  
DB ID KNIME ID  
1234 1234.0  
This is quite annoying when trying to use them in the joiner, as your data is not formatted as you wanted it to be...

Maybe would it be useful to let the user manually define the column type (Integer, Decimal) of the data extracted from a database ? This feature is actually available in the file Reader, but not in the database reader.

Thanks !

---

<div class="post-metadata">

**Author:** ![unknown\_user](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/u/ac91a4/32.png) [@unknown\_user](https://forum.knime.com/u/unknown_user)\
**Post date:** [August 20, 2008, 3:26pm UTC](https://forum.knime.com/t/database-reader-wrong-data-types/302/2 "2008-08-20T15:26:40Z")

</div>

Hello, data columns are either return as double or integer, or string depending on the underlying meta data of the DB. As far as I know, in oracle you only have type numeric (instead of double or integer) which is then returned as double in KNIME. However, I came across the same problem. It looks like if we need a node to do this transformation manually.  
Regards, Thomas

---

<div class="post-metadata">

**Author:** ![unknown\_user](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/u/ac91a4/32.png) [@unknown\_user](https://forum.knime.com/u/unknown_user)\
**Post date:** [August 21, 2008, 4:58pm UTC](https://forum.knime.com/t/database-reader-wrong-data-types/302/3 "2008-08-21T16:58:48Z")

</div>

Seems to be a good solution.  
Thanks a lot !

---

<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:14pm UTC](https://forum.knime.com/t/database-reader-wrong-data-types/302/4 "2023-06-23T20:14:25Z")

</div>


