Inserting A Long Text In H2 Database From An SQL Script
I'm trying to run a sql script using H2's runscript. One of the table contains a longtext type which stores an xml document (from an SAP database) So the Insert statement contains
Solution 1:
Never mind
Got it working by using the proper delimiters (" for column names and ' for values) and escaping quotes in values properly (doubling it)
Post a Comment for "Inserting A Long Text In H2 Database From An SQL Script"