# Oracle XMLTypes Support

**URL:** <https://forum.liquibase.org/t/oracle-xmltypes-support/341>\
**Category:** General Discussion\
**Created:** [November 6, 2009, 12:38pm UTC](https://forum.liquibase.org/t/oracle-xmltypes-support/341 "2009-11-06T12:38:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![porterhouse91](https://avatars.discourse-cdn.com/v4/letter/p/c67d28/32.png) [@porterhouse91](https://forum.liquibase.org/u/porterhouse91)\
**Post date:** [November 6, 2009, 12:38pm UTC](https://forum.liquibase.org/t/oracle-xmltypes-support/341/1 "2009-11-06T12:38:00Z")

</div>

First off, let me start of my saying I am quiet impressed with Liquibase and I am excited about integrating it’s use on my team.&nbsp; We are utilizing Oracle’s XMLType column on our project and I was impressed to see that Liquibase recognizes the column type.&nbsp; Oracle XMLType columns have four main storage options:

- Clob XML Storage
- Object Relational XML Storage
- Object Relational Storage
- Binary XML Storage (New in Oracle 11g)

Liquibase creates the XMLType column as a Clob XML Storage and our team requires a Binary XML Storage.&nbsp; Does anybody know of a way to change this configuration or does Liquibase not support this column type configurations?&nbsp; (For an overview of Oracle’s XMLType columns, see [http://www.liberidu.com/blog/?p=203)](http://www.liberidu.com/blog/?p=203))

---

<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:** [November 6, 2009, 12:38pm UTC](https://forum.liquibase.org/t/oracle-xmltypes-support/341/2 "2009-11-06T12:38:00Z")

</div>

There is no direct support for XML types, but they can be used still.&nbsp; The datatType attribute in the createTable/column nodes, for example, will take whatever string you put in and pass it to the database as the data type.&nbsp; If the standard tags do not do what you need, you can always use the tag:

&nbsp; CREATE TABLE XMLBIN of XMLType XMLTYPE store AS BINARY XML

Does that help?

Nathan

---

<div class="post-metadata">

**Author:** ![porterhouse91](https://avatars.discourse-cdn.com/v4/letter/p/c67d28/32.png) [@porterhouse91](https://forum.liquibase.org/u/porterhouse91)\
**Post date:** [November 6, 2009, 12:38pm UTC](https://forum.liquibase.org/t/oracle-xmltypes-support/341/3 "2009-11-06T12:38:00Z")

</div>

Thanks Nathan…this does look like it will be able to solve my problem.&nbsp; Thanks for the feedback!&nbsp; I will try this out and then post any additional questions/concerns.  
Thanks!