# Inserting a CLOB

**URL:** <https://forum.liquibase.org/t/inserting-a-clob/2793>\
**Category:** General Discussion\
**Created:** [December 6, 2013, 1:52am UTC](https://forum.liquibase.org/t/inserting-a-clob/2793 "2013-12-06T01:52:00Z")\
**Posts on this page:** 3\
**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:** [December 6, 2013, 1:52am UTC](https://forum.liquibase.org/t/inserting-a-clob/2793/1 "2013-12-06T01:52:00Z")

</div>

I need to insert a CLOB in a table.

Base on the&nbsp;[Forum information](http://forum.liquibase.org/topic/blob-clob-support "In the Liquibase Forum")

1. 
2. &nbsp; &nbsp; 
3. SEVERE 5/12/13 18:44:liquibase: cvc-complex-type.3.2.2 : L'attribut 'valueClob' n'est pas autorisÚ dans l'ÚlÚment 'column'.

Any idea ?

\T,

---

<div class="post-metadata">

**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\
**Post date:** [December 6, 2013, 1:52am UTC](https://forum.liquibase.org/t/inserting-a-clob/2793/2 "2013-12-06T01:52:00Z")

</div>

I think the problem is that the column type is CLOB (Character Large Object) but you are trying to store an image. If you want to store an image, use BLOB (Binary Large Object).

---

<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:** [December 6, 2013, 1:52am UTC](https://forum.liquibase.org/t/inserting-a-clob/2793/3 "2013-12-06T01:52:00Z")

</div>

It looks like the XSD is complaining about the valueClob attribute. Make sure the XML header has the most liquibase XSD version listed

Nathan
