Apostrophe in text variable causes SQL syntax error

[Terry Judd]

I'm trying to poke some text into a field in a mySQL table using some simple
statements like the following...

put "INSERT INTO screens VALUES(:1,:2,:3)" into tQuery
revExecuteSQL tID, tQuery, "screenID","screenXML","screenText"

...(fields 2 and 3 are both TEXT fields) and am getting an SQL syntax error
if either of the text variables contain an apostrophe. I can escape the
character I suppose but is this behaviour normal?

Terry...