[
https://issues.apache.org/jira/browse/NETBEANS-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884647#comment-16884647
]
Pete Whelpton commented on NETBEANS-2846:
-----------------------------------------
Which RDBMS are you using? MySQL?
For most RDBMS, single quotes are escaped with another single quote. E.g.
{{UPDATE test SET val='test '' test' WHERE id = 1;}}
should lex/parse correctly. I think escaping with \' is specific to MySQL (and
perhaps a few others), but escaping with '' is more common/portable?
> Escape symbol brokes SQL file highlighting
> ------------------------------------------
>
> Key: NETBEANS-2846
> URL: https://issues.apache.org/jira/browse/NETBEANS-2846
> Project: NetBeans
> Issue Type: Bug
> Components: db - SQL Editor
> Affects Versions: 11.0
> Reporter: Lobzek
> Priority: Minor
> Attachments: Untitled.png
>
>
> Escape symbol ' brakes SQL file highlighting when using inside string value.
> SQL query for example:
> {code:java}
> UPDATE test SET val='Test \' test' WHERE id = 1;
> {code}
> See also attached screenshot
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
