# Invalid SQL generated (tinyblob with size specified)

**URL:** <https://forum.liquibase.org/t/invalid-sql-generated-tinyblob-with-size-specified/592>\
**Category:** General Discussion\
**Created:** [July 5, 2010, 7:55am UTC](https://forum.liquibase.org/t/invalid-sql-generated-tinyblob-with-size-specified/592 "2010-07-05T07:55:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![remboooo](https://avatars.discourse-cdn.com/v4/letter/r/ecb155/32.png) [@remboooo](https://forum.liquibase.org/u/remboooo)\
**Post date:** [July 5, 2010, 7:55am UTC](https://forum.liquibase.org/t/invalid-sql-generated-tinyblob-with-size-specified/592/1 "2010-07-05T07:55:00Z")

</div>

I am currently trying to let Liquibase do database versioning for a MySQL database used by Hibernate.  
My first test case is to make an empty database, and let liquibase ‘update’ it to a correct table structure to go with the hibernate configuration file.  
This immediately led to a problem; the SQL Liquibase generates contains column types of the form ‘tinyblob (255)’, but this is invalid SQL syntax; you cannot specify a size for a tinyblob (at least not in the MySQL version we use). Interestingly, this is also the only type it outputs in lower case (maybe this indicates where the problem lies?). Does anyone know how to tell liquibase (or com.mysql.jdbc.Driver ?) not to specify a size for a tinyblob? Thanks in advance 🙂

---

<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:** [July 5, 2010, 7:55am UTC](https://forum.liquibase.org/t/invalid-sql-generated-tinyblob-with-size-specified/592/2 "2010-07-05T07:55:00Z")

</div>

What version of liquibase are you running?

Nathan

---

<div class="post-metadata">

**Author:** ![remboooo](https://avatars.discourse-cdn.com/v4/letter/r/ecb155/32.png) [@remboooo](https://forum.liquibase.org/u/remboooo)\
**Post date:** [July 5, 2010, 7:55am UTC](https://forum.liquibase.org/t/invalid-sql-generated-tinyblob-with-size-specified/592/3 "2010-07-05T07:55:00Z")

</div>

This was done using 1.9.5. Interestingly, using 2.0 RC1 (have not tried it with 1.9.5) and PostreSQL gives the same problem, only not for a ‘tinyblob’ but ‘bytea’.

---

<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:** [July 5, 2010, 7:55am UTC](https://forum.liquibase.org/t/invalid-sql-generated-tinyblob-with-size-specified/592/4 "2010-07-05T07:55:00Z")

</div>

It should work in RC2.&nbsp; Working on releasing it now…

Nathan