go to bug id or search bugs for
For storing unicode text MSSQL has nchar and nvarchar column types
However, pdo_dblib extension does not correctly escapes unicode strings.
Those strings must be prefixed with N prefix - e.g.
INSERT INTO table(field) (N'unicode_value')
UPDATE table SET field = N'unicode_value' WHERE code = N'unicode_value'
Likewise binary, varbinary and blob should be escaped like unquoted hexadamical notation starting with 0x - e. g.
INSERT INTO table(binfield) (0xAAFFCC)
UPDATE table SET binfield = 0xAAFFCC WHERE code = 0xCCAAFF
Add a Patch
Add a Pull Request
I can confirm this is an issue for a long time now. This fix will remove the need for the workaround in Propel ORM 1.7.x runtime/lib/adapter/DBMSSQL.php cleanupSQL method.
Related To: Bug #70565
This is a limitation of how PDO handles types. See #60818 for a request to allow NVARCHAR quoting.