# Modify data type from varchar to Blob in Sybase.

**URL:** <https://forum.liquibase.org/t/modify-data-type-from-varchar-to-blob-in-sybase/2824>\
**Category:** General Discussion\
**Created:** [January 7, 2014, 9:10pm UTC](https://forum.liquibase.org/t/modify-data-type-from-varchar-to-blob-in-sybase/2824 "2014-01-07T21:10:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [January 7, 2014, 9:10pm UTC](https://forum.liquibase.org/t/modify-data-type-from-varchar-to-blob-in-sybase/2824/1 "2014-01-07T21:10:00Z")

</div>

On Sybase ASE when I try to modify the data type of a column from varchar to blob its giving me this error,any help??

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [January 7, 2014, 9:10pm UTC](https://forum.liquibase.org/t/modify-data-type-from-varchar-to-blob-in-sybase/2824/2 "2014-01-07T21:10:00Z")

</div>

Thanks … sorry i meant from Varhcar to Clob.That modification is also throwing the same error

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [January 7, 2014, 9:10pm UTC](https://forum.liquibase.org/t/modify-data-type-from-varchar-to-blob-in-sybase/2824/3 "2014-01-07T21:10:00Z")

</div>

That is an error from Sybase, not from Liquibase. You are doing something invalid - it doesn’t make sense to convert a column that contains text to a column of binary data.&nbsp;

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [January 7, 2014, 9:10pm UTC](https://forum.liquibase.org/t/modify-data-type-from-varchar-to-blob-in-sybase/2824/4 "2014-01-07T21:10:00Z")

</div>

Liquibase doesn’t try to do anything beyond the sql you are seeing in the log. It looks like it got cut off in what you posted, but the data conversion is failing in sybase.

Compare the generated SQL to what does work. What do you see as a different?

Nathan