I am dealing with some data that is a bit dirty, but I would still expect
this to work. I am trying to insert a text string that is 'Starbucks' WITH
a single quote at the start and at the end.
The SQL statement I generate is
Insert into PAYEES (NAME) values('''Starbucks''')
(its not that obvious in google's font, but there are 3 single quotes
before and after Starbucks). According to Oracle, that is the way they do
it.
In H2 I getand error of:
SQLState: 42001
Error Code: 42001
Message: Syntax error in SQL statement "INSERT INTO PAYEES (NAME)
VALUES(NULL'StarbucksNULL'[*]) "; expected "[, ::, *, /, %, +, -, ||, ~,
!~, NOT, LIKE, REGEXP, IS, IN, BETWEEN, AND, OR, ,, )"; SQL statement:
Insert into PAYEES (NAME) values(NULL'StarbucksNULL') [42001-168]
Is there a way to do this, or do I need to start checking all the fields to
clean up?
And who knows, someone might want the quote.
--
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/-/zDHHF6esKkkJ.
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.
