SQL editor, syntax highlight bug if '' was used

[maqiushi]

As described in the attached file.
If we use some kind of too much quotation marks in the SQL query. The SQL syntax highlight not work after ''
If we add a single quotation mark in a comment, it behaves correct.

Looks like a bug here.

Is there anyway we can correct this by some preference settings?

Thanks,
Qiushi

[lopard]

Another highlight bug

after this line l_str := REPLACE(l_str,'\','\\') ; the lighlight not work properly. I think the problem is the double /

[Serge]

Actually problem is in the slash followed by ' symbol. In string literals single slash has to be escaped as \\.
It is SQL dialect dependent issue. Some dialects do not require to escape \.
What database/driver do you use?