# Dremio error in version 18.1 (Unable to coerce from the file's data type "varbinary" to the column's data type "varchar" in table)

**URL:** <https://community.dremio.com/t/dremio-error-in-version-18-1-unable-to-coerce-from-the-files-data-type-varbinary-to-the-columns-data-type-varchar-in-table/8094>\
**Category:** Site Feedback\
**Created:** [October 5, 2021, 8:19pm UTC](https://community.dremio.com/t/dremio-error-in-version-18-1-unable-to-coerce-from-the-files-data-type-varbinary-to-the-columns-data-type-varchar-in-table/8094 "2021-10-05T20:19:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlcornejo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jlcornejo/32/3499_2.png) [@jlcornejo](https://community.dremio.com/u/jlcornejo)\
**Post date:** [October 5, 2021, 8:19pm UTC](https://community.dremio.com/t/dremio-error-in-version-18-1-unable-to-coerce-from-the-files-data-type-varbinary-to-the-columns-data-type-varchar-in-table/8094/1 "2021-10-05T20:19:13Z")

</div>

Dremio version 18.1 generates an error in some VDS, this does not happen in 17.0

Error:

> Unable to coerce from the file’s data type “varbinary” to the column’s data type “varchar” in table “ops\_dao.tarificador.machines”, column “implementations.\_id”.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a0760a1184df3ba2e7507d838a46772e38df54c1.png)

\*I am migrating my VDS from 17.0 to 18.1  
\*the only error I have in the whole development,  
I do not understand the error

---

<div class="post-metadata">

**Author:** ![jlcornejo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jlcornejo/32/3499_2.png) [@jlcornejo](https://community.dremio.com/u/jlcornejo)\
**Post date:** [October 5, 2021, 8:20pm UTC](https://community.dremio.com/t/dremio-error-in-version-18-1-unable-to-coerce-from-the-files-data-type-varbinary-to-the-columns-data-type-varchar-in-table/8094/2 "2021-10-05T20:20:08Z")

</div>

mongoDB

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/619a282a049cde5b9e652138547cfca08c46c8c5.png)

---

<div class="post-metadata">

**Author:** ![luissotosanchez](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@luissotosanchez](https://community.dremio.com/u/luissotosanchez)\
**Post date:** [October 5, 2021, 9:40pm UTC](https://community.dremio.com/t/dremio-error-in-version-18-1-unable-to-coerce-from-the-files-data-type-varbinary-to-the-columns-data-type-varchar-in-table/8094/3 "2021-10-05T21:40:51Z")

</div>

Currently having the same issue, even if the message points a especific column when i exclude that column from the select statement i get the same error. having the same vds on an earlier version of dremio works as expected.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [October 7, 2021, 3:52am UTC](https://community.dremio.com/t/dremio-error-in-version-18-1-unable-to-coerce-from-the-files-data-type-varbinary-to-the-columns-data-type-varchar-in-table/8094/4 "2021-10-07T03:52:12Z")

</div>

@jlcornejo @luissotosanchez in 18.0 mixed types are no longer supported, there are certain types, Dremio can coerce while some it cannot