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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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.