I'm writing Tcl with SQlite in Kate and have a replace( ...text..., '"', '\"' ) in one of my SQL statements to escape the quotation marks. This causes Kate to turn all the code after this line red because of the unpaired quotation marks. The code runs successfully but it's a bit annoying to look at now.
Am I dong something wrong and/or is there a way to change this behavior?
Thank you.
ADDITION:
This isn't a Kate solution exactly but SQlite has a char() function that returns strings based on their unicode value. So, this removed the need for typing the quotation marks.
replace( ...text..., char(34), '\' || char(34) )
