MySQL do not save backslash why?

[mshen]

I use php addslash function to add back slash to the special characters.

but when I run a SQL statement like this:

INSERT INTO survey_questions_description (question_content, survey_id,page_id,order_in_survey,order_in_page,question_type_id) VALUES ('hh \ \' jkjdks\'fkf',448,774,1,1,1)

when I see the data in DB, the saved data is hh \ ' jkjdks'fkf,
not hh \ \' jkjdks\'fkf. the back slash lost. why? I guess I have to change MYSQL settings.but I do not know how to do.

Please let me know how to change MYSQL setting.

Thanks a lot

[laserlight]

That is correct.
\ is escaping of a backslash, hence you have 1 backslash in the result.

At the same time, \' is the escaping of a single quote, hence you only have the single quote.

What you might have to use is:

\\
and
\\'