Using quote ( ' ) in insert statement

[Paul Sanderson]

Hi All

I am trying to insert a string into a varchar. The problem occurs when I try and instert a string which already contains a quote i.e.

sampson's files

as the string is also delimited by a quote character i get an error "missing right quote"

I tried escaping the quote character and this does not have any affect.

As the string I am inserting is a path name then I need to record this character properly - other than converting the quote before insertion using my own routines and converting back when read - is there a way around this?

I am using MySQL server 5.0 on a Windows platform