How insert query with right single quotation mark in Mysql in C#

[samour]

hello every body

how can i get red of this error :
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near"

when i insert a new category in database i get this error since category name include single quotation mark.

example of Category name not accepted : un’ mecca

C;f : SELECT IdCategoria FROM categoria WHERE categoria.title='Familly’Ceka'

FYI : i use string.format() to design my query.

Please try to help me.

[mwasif]

You need to escape quotation mark with \ e.g.

SELECT IdCategoria FROM categoria 
WHERE categoria.title='Familly\’Ceka'

[samour]

thanks mwasif

it does'nt work, when i perform another replace like this :
ObjCategory.CategoryTitle.Replace("'", "''").Replace("’", @"\’")
the right single quotation mark will became a simple apostrophe.

- and when i update the category title directly in Mysql query browser, it accept this but when i wanna display categories in web application teh right single quotation mark will be shown like quarry

[mwasif]

I am moving this thread to C# for better response.