This is an XML issue, its worth learning how to represent special characters in XML statements (or use sqlfile). The following conversions will do the job:
Ampersand—&—&
greater-than—>—>
less-than—<—<
apostrophe—'—'
quote—"—"
----- Original Message ----
From: LiquiBase Community Forum <
nathan@...>
To:
Liquibase-user@...
Sent: Thursday, 11 June, 2009 18:00:40
Subject: [Liquibase-user] New Topic: Imbedded & and tag characters (<) in data in sql statement
A new topic, 'Imbedded & and tag characters (<) in data in sql statement', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=46.new#newThe text of the topic is shown below:
This does not work: <sql>INSERT INTO my_table (my_column) VALUES ('XXX<A bbb>$$&ddddd')</sql>
If I add SET ESC and change the & to & it still fails.
Any ideas about how I get that '&' in?
I expect the <A bbb> will also fail, since Eclipse is highlighting it as a problem.
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.
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user
