Enabling ATTR_EMULATE_PREPARES breaks binary bindings

[david-garcia-garcia]

Sample script here: http://pastebin.com/qXBJYDiP

Updating binary columns with EMULATE_PREPARES turned OFF works,

From the profiler I can see that the queries it is running against the server are messed up for binary columns with EMULATE_PREPARES ON.

Without emulate prepares:

exec sp_executesql N'INSERT INTO TESTTABLE VALUES(@p1)',N'@p1 varbinary(max)',0x61736467617364676173646773616467

With emulate prepares:

INSERT INTO TESTTABLE VALUES('asdgasdgasdgsadg')

When it should be doing:

INSERT INTO TESTTABLE VALUES(0x61736467617364676173646773616467)

I'm running latest version of the PDO driver.

[david-garcia-garcia]

This is still an issue in the PHP7 driver.

The test runs first a successful insert statement (with emulate prepares off), the tries the same thing with (emulate prepares on) resulting in an exception.

[david-garcia-garcia]

This is fixed in the latest release. Thanks!