insert value in Mysql containg single quotes

Question

How do I insert a Value in Mysql that consist of single of Double Quotes. i.e,

Value: This is Ashok's Pen.

This Single Quote will create problems.

There might be other escape characters...

How to insert the data properly..

Thanks in advance for ur precious time..

Answer 1

' is the escape character. So your string should be: This is Ashok''s Pen

Edit:

If you are using some front-end code, you need to do a string replace before sending the data to the SP.

For eg. in C# you can do

value = value.Replace("'","''");

and then pass value to SP.

Answer 2

Put quite simply:

SELECT 'This is Ashok''s Pen.';

So inside the string, replace each single quote with two of them.

Or:

SELECT 'This is Ashok\'s Pen.'

Escape it =)

Answer 3

See my answer to "How to escape characters in MySQL"

Whatever library you are using to talk to MySQL will have an escaping function built in, e.g. in PHP you could use mysql_real_escape_string

Answer 4

You should escape the special characters using the \ charactor.

This is Ashok's Pen.

becomes;

This is Ashok\'s Pen.