Skip to content Skip to sidebar Skip to footer

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"