Hello all,
I was hoping I could get some advice on bug #44643
(http://bugs.php.net/bug.php?id=44643), where queries with bound
parameters made with the PDO ODBC driver do not have the correct type,
causing SQL errors in MSSQL (we're seeing this through the Doctrine
ORM).
I've read through the notes at
http://wiki.php.net/internals/pdo/brainstorming#pdo_binding_behaviour_5.
3 and it seems that at the moment the PDO ODBC driver converts all
parameters to strings. The RFC on that page suggests changes to ensure
the type of each parameter is dependent on its zval. Have those changes
been applied? Do they relate to this bug?
There is also this bug report
(https://connect.microsoft.com/SQLServer/feedback/details/521409/odbc-cl
ient-mssql-does-not-work-with-bound-parameters-in-subquery) on Microsoft
Connect that suggests the issue goes beyond the PDO layer and is in
their ODBC driver instead, since the same behaviour is seen when using
the SQL Server Driver for PHP.
I'd be grateful for any advice regarding this matter, since I have
little knowledge of PDO. If the problem is with the ODBC PDO driver we'd
be happy to try to work up a patch for it - if it goes beyond PHP how
can I take the issue further?
Thanks,
Craig
Craig Marvelley
Box UK
Internet Development and Consultancy
t: +44 (0) 292 022 8822
f: +44 (0) 292 022 8820
e: craig.marvelley@boxuk.com
w: http://www.boxuk.com http://www.boxuk.com
Eight years in the making and more investment in usability than any
other Content Management System. Visit http://www.amaxus.com
http://www.amaxus.com/ and find out why hundreds of websites are
powered by Amaxus.
Registered Office Address: 6a Poland Street, London, W1F 8PT. Registered
in England and Wales No. 3606919.
Important Information: This message may contain confidential,
proprietary or privileged information. If you are not the intended
recipient, please notify the sender immediately and delete the message
from your system. You should not copy or use it for any purpose, nor
disclose its contents to any other person.