How to check apostrophe in a inserted string

r k

5y2.7kAJAX

How will i find an aprostophe (single quote ) in jquery if user has in it's message . If it is there the replace or escape because sql server doesnot accept single quotes.

If message does not contain single quote the i want to send message as message because message may have image files , tables or videos .

i am trying this

var message = contents.replace(/[!'()*&"<>]/g, escape);

but it is saving like below in db & giving user

%3Cp%3Ethis isn%27t good it%27s not saving%26nbsp;%3C/p%3E

Also if i will not put a check then it saves the video's the same way

Please help

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtesh Shah5y ago
Accepted answer
Try this example, you can undestand better
string test = "this is ' sample text";
if(test.Contains("'"))
{
Console.WriteLine("single quote present");  }
Hope it will help.
+1
Sachin Singh5y ago
don't worry if it will not find then it will not replace anything so doesn't matter.
However, you can check with
if (Message.Contains("'"))
{
// do yr work here
}
+1
r k5y ago
But first i have to check in the string weather it contains a single quote . So how i find that it contains? Please reply
+1
Sachin Singh5y ago
at first SQL Server does understand the single quote, you just need to replace the single quote to a double quote in order to consider it as a single quote by SQL server.

var message = contents.Replace("'","\"");
+2