Re: Can't seem to get a single quote at the beginning and end of a string

36 views
Skip to first unread message

Thomas Mueller

unread,
Jul 27, 2012, 7:04:26 AM7/27/12
to h2-da...@googlegroups.com
Hi,

The SQL statement looks good to me:

Insert into PAYEES (NAME) values('''Starbucks''')

Regards,
Thomas

Brian

unread,
Jul 28, 2012, 2:57:13 PM7/28/12
to h2-da...@googlegroups.com

Just tried this from the console and it works for me.  I'd start looking at the environment your interacting with the database from - perhaps _it_ has unanticipated behavior single quote escaping.
Reply all
Reply to author
Forward
0 new messages