Bad escaping caracter for SQL server when use compare about yii HOT 2 CLOSED

@Shnoulle CDbCriteria addSearchCondition only escapes the special characters mensioned here: https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html#operator_like

A workaround is to apply your own escape function and call CDbCriteria->compare() with the last argument escape: false (https://www.yiiframework.com/doc/api/1.1/CDbCriteria#compare-detail)

This will be hard to fix on the framework level in Yii 1, since there is no MSSQL specific override available here. Even then, fixing it in a backward compatible way will be hard since people might have applied workarounds even with $escape=true. I'm afraid this will stay a known issue.

from yii.

This will be hard to fix on the framework level in Yii 1, since there is no MSSQL specific override available here. Even then, fixing it in a backward compatible way will be hard since people might have applied workarounds even with $escape=true. I'm afraid this will stay a known issue.

Yes i try to extend CDbCriteria too but must update all new CDbCriteria to new ownCDbCriteria …

I hate MS ;)

from yii.