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 9, 2015 at 2:40 PM, Vijay Vangapandu <VijayVangapandu@eharmony.com> wrote:
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 query, but is there any better or suggested way of handling this case?

ex: upsert into user_address (uid, city, state, country) values(123, ‘L’Anse’, ‘MI’, ‘USA’)


Thanks,
Vijay.