This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 152325 - Escaping single quotes in SQL by using backslashes
Summary: Escaping single quotes in SQL by using backslashes
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Skrivanek
URL:
Keywords:
: 155079 250383 (view as bug list)
Depends on:
Blocks: 152772
  Show dependency tree
 
Reported: 2008-11-04 17:40 UTC by dkkeen
Modified: 2015-02-26 18:54 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description dkkeen 2008-11-04 17:40:34 UTC 
MySQL supports escaping single quotes by using backslashes however the following breaks syntax highlighting in the editor:

INSERT INTO `country` (`country_code`, `country`) VALUES ('CI','Cote d\'Ivoire');
Comment 1 David Vancouvering 2008-11-04 17:45:40 UTC 
Sounds like a bug, not an enhancement request.
Comment 2 Jiri Rechtacek 2009-02-10 15:27:42 UTC 
Reassigned to new owner.
Comment 3 Jiri Rechtacek 2009-05-12 16:50:37 UTC 
*** Issue 155079 has been marked as a duplicate of this issue. ***
Comment 4 Jiri Skrivanek 2009-08-26 08:14:47 UTC 
Fixed.
core-main #0c16dad74c31
Comment 5 Quality Engineering 2009-08-26 17:52:08 UTC 
Integrated into 'main-golden', will be available in build *200908261401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/0c16dad74c31
User: Jiri Skrivanek <jskrivanek@netbeans.org>
Log: #152325 - Parse correctly escaped simple quote within string literal.
Comment 6 matthias42 2015-02-26 18:54:06 UTC 
*** Bug 250383 has been marked as a duplicate of this bug. ***