If tDescription is a variable with your special characters, then the following will work.. revExecuteSQL databaseID, "INSERT INTO MyTable (id, description) VALUES (0, :1)", "tDescription" The :1 in the query is replaced with the tDescription variable - check out revExecuteSQL in the LiveCode diction...