A new topic, 'Encoding of value for columns of type BLOB?', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=217.new#newThe text of the topic is shown below:
Hi there,
Using the insert tag with a type 'BLOB' I'm able to insert some binary data, e.g.:
<insert tableName="Picture">
...
<column name="data" type="BLOB" value="xyz1234" />
</insert>
But how is the value supposed to be encoded in this case? Does Liquibase (1.9.5 or 2.x) use the encoding of the changelog
or another one, e.g. Base64? (since < is disallowed in attributes, for example)
Because the contents of attributes in XML schema is rather limited, I can't imagine something different than Base64 but
unfortunately the documentation does not touch this point. Can someone shed some light on this topic?
If this is an open issue, I would suggest using an inner element for value instead, because then a different schema type
could be used for the different value types, something like:
<column name="data" type="BLOB">
<value xsi:type="xs:base64Binary">xyz1234"<value>
</column>
thanks,
Robin.
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-july_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user
