[BUG] SQL code color coding incorrect

[AlexMineware]

Is there an existing issue for this?

• I have searched the existing issues

Description of the Issue

In my example of the SQL I copied & paste from the SQL editor, the color coding goes wonky, even with the SQL escape charater setting ticked.

sql_display.zip

Steps To Reproduce

1. unzip attached zip
   sql_display.zip

2. copy the code from the sql file into notepad++

3. from line 64 the display goes wrong

Current Behavior

the display goes wrong from line 64

Expected Behavior

the sql should be displayed correctly

Debug Information

Notepad++ v8.6.5   (64-bit)
Build time : Mar 29 2024 - 17:04:43
Path : C:\Program Files\Notepad++\notepad++.exe
Command Line : "\\sgl-ldc-fs05.sibanyestillwater.com\Mineware\Releases\Plat\Release_20230823_PlanningAPI\Scripts\DBChanges_MAR.sql"
Admin mode : OFF
Local Conf mode : OFF
Cloud Config : OFF
Periodic Backup : ON
OS Name : Windows 11 Pro for Workstations (64-bit
OS Version : 23H2
OS Build : 22631.3447
Current ANSI codepage : 1252
Plugins : 
    ComparePlugin (2.0.2)
    DSpellCheck (1.4.23)
    mimeTools (3.1)
    NppConverter (4.6)
    NppExport (0.4)
    NPPJSONViewer (2.0.4)
    PoorMansTSqlFormatterNppPlugin (1.6.13.31508)
    XMLTools (3.1.1.12)

Anything else?

No response

[rdipardo]

the color coding goes wonky, even with the SQL escape chara[c]ter setting ticked.

So clear the checkbox and see what happens.

• I have searched the existing issues

And did you find these?

• Ignore single quote escaping in LIKE ... ESCAPE ... clause #14813
• SQL Language stops color coding mid file with specific (valid sql) string is present #14463
• Error with the SQL syntax highlighting.  #14241
• Incorrect color coding #13963
• SQL Syntax Highlighter Issue with CASE statement #12610
• SQL syntax highlighter misinterprets backslash as an escaping character which is generally not present in SQL strings #10835
• For SQL Language coloring mistaking a literal for an escaped character #9040
• SQL Language Colorizing Display Issue with \' #8919
• SQL highlighting corrupted by Slash in Strings #7825
• SQL Language color gets confused  #5551
• Bug in Coloring in SQL Code  #4866
• syntax highlighting: sql : literal string  #4743
• SQL formatting problem if using \ character in file #3862
• SQL Server file: Improper parsing/handling of Single Quote count where the syntax looks to be part of the string but it is not.. #3816
• "Treat backslash as escape characters for SQL" fails for SQLCMD mode :setvar script #3297
• SQL language option treats \ as an escape character, when SQL does not (V7.3.3) #3187
• .SQL file loses syntax highlighting if the three characters '\' are on a line #2451
• Error with SQL highlighting #1330
• SQL colorization changed in error by code. #704