Problem with unicode quotes in Transact-SQL

[GregObleshchuk]

Describe the bug
An Unexpected Error Occurred
Parse error: Unexpected "​'@p0​' an" at line 5 column 4. SQL dialect used: "transactsql".

Please report this at Github issues page.

Stack Trace:

Error: Parse error: Unexpected "​'@p0​' an" at line 5 column 4.
SQL dialect used: "transactsql".
at T.default.createParseError (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:278047)
at T.default.tokenize (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:277813)
at T.default.tokenize (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:272790)
at T.default.tokenize (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:287994)
at T.default.reset (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:286521)
at T.S.feed (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:312761)
at Object.parse (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:288132)
at T.default.parse (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:16545)
at T.default.format (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:16443)
at T.formatDialect (https://unpkg.com/sql-formatter@latest/dist/sql-formatter.min.js:1:307558)

format the SQL text

Actual behavior
What happened instead?

Usage
used: https://sql-formatter-org.github.io/sql-formatter/
used transact-SQL

My input text

select 
top @p1 ltrim(rtrim(long_matt_name)) 
from sl_hbm_matter where matter_uno = @p2 and
 CONVERT(DATETIME,CONVERT(VARCHAR(@p3), last_modified)) 
<= ​'@p0​' and CONVERT(DATETIME,CONVERT(VARCHAR(@p3), sl_entry_date))
 >= ​'@p0​' order by sl_entry_date desc

[nene]

This problem is caused by special Unicode characters in your string literals:

​'@p0​'

which is a sequence of:

  ┌─────┬─────────────┬───────────┬─────────────────────────────┐                                                               
  │  #  │    Char     │ Codepoint │            Name             │                                                               
  ├─────┼─────────────┼───────────┼─────────────────────────────┤                                                               
  │ 1   │ (invisible) │ U+200B    │ ZERO WIDTH SPACE            │                                                             
  ├─────┼─────────────┼───────────┼─────────────────────────────┤                                                               
  │ 2   │ '           │ U+2018    │ LEFT SINGLE QUOTATION MARK  │                                                             
  ├─────┼─────────────┼───────────┼─────────────────────────────┤
  │ 3   │ @           │ U+0040    │ COMMERCIAL AT               │
  ├─────┼─────────────┼───────────┼─────────────────────────────┤                                                               
  │ 4   │ p           │ U+0070    │ LATIN SMALL LETTER P        │
  ├─────┼─────────────┼───────────┼─────────────────────────────┤                                                               
  │ 5   │ 0           │ U+0030    │ DIGIT ZERO                  │                                                             
  ├─────┼─────────────┼───────────┼─────────────────────────────┤
  │ 6   │ (invisible) │ U+200B    │ ZERO WIDTH SPACE            │
  ├─────┼─────────────┼───────────┼─────────────────────────────┤                                                               
  │ 7   │ '           │ U+2019    │ RIGHT SINGLE QUOTATION MARK │
  └─────┴─────────────┴───────────┴─────────────────────────────┘

Are you intentionally using such special symbols in your code?