phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vijay Vangapandu <VijayVangapa...@eharmony.com>
Subject Issue with single quote in columns with String data type
Date Mon, 09 Nov 2015 22:40:51 GMT
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.


Mime
View raw message