Hi, The escape character for an apostrophe is a single apostrophe, as in Oracle.
Regards, Thomas On Tue, Jun 19, 2012 at 7:44 AM, Guys <[email protected]> wrote: > Hello > > I have a table with a varchar2 column that should contain sql statement. The > problem is that if the sql statement contains an apostrophe "'" then my > insert statement fails. > for example: > insert into scripts (id,text) values (1,'select * from all_objects where > status='INVALID''); (note the double apostrophe at the end). > I originally come from oracle, where you can escape this using three > apostrophes (''') but it doesnt seem to work in H2. > > How can I escape the ' character in H2 ? > > Thanks > > Guy > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/W7CycwwFVa8J. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
