Adding NN to query with SqlsrvDriver (Dibi\Fluent)

[TumaMilan]

Specification

When specifying string value in query, datagrid adds two "N" before leading string apostrophe.
For example:
$fluent->where("type = 'type1'") datagrid represents as "WHERE type = NN'type1'"

Source

I guess the reason is double calling of method escapeText() from SqlsrvDriver. Dibi from version 4.1 adds "N" before escaped text. Calling once is OK, calling twice doubles leading "N", which MSSQL server doesn't understand.

Workaround

• delete "N" from this method in SqlsrvDriver.php or
• use Dibi 4.0.3 or older

[radimvaculik]

Hi @TumaMilan, I believe this is fixed in #1274.

The root cause was the applyFilterText() override in DibiFluentMssqlDataSource — it used direct string interpolation and %s in a way that caused SqlsrvDriver (Dibi 4.1+) to call escapeText() twice, producing NN'...'. The fix removes the broken override and lets the base class handle text filtering via Dibi's %~like~ modifier, which calls the driver's escape method exactly once.

Could you test the fix against your setup and confirm it resolves the issue? Thanks!