Hi Guys,
Does any one encounter a situation where single quote needs to be inserted into
String data type column. ex: I am trying insert “xxx’y” in to the city column
of my address table, but causing issue at insert time due to query contains
quote.
I can escape the quote before executing the
Either escape the quote by using two of them in a row like this:
upsert into user_address (uid, city, state, country) values(123,
‘L'’Anse’, ‘MI’, ‘USA’)
or use bind parameters like this:
upsert into user_address (uid, city, state, country) values(?, ?, ?, ?)
Thanks,
James
On Mon, Nov