I'm using the following setup to access a MS-SQL database from a PHP application
foo, :bar');$stmt->bindValue(':foo', 21, PDO:
ARAM_INT);$stmt->bindValue(':bar', 42, PDO:ARAM_INT);$stmt->execute():if (!$stmt->execute()) { var_dump($stmt->errorInfo();}\[/code\]Where both columns are INT. I get the an "206 [FreeTDS][SQL Server]Operand type clash: text is incompatible with int [SQLSTATE=22018]" error.In the unixODBC log, I get something like\[code\][ODBC][26251][SQLDescribeParam.c][175] Entry: Statement = 0x2b73c849fb80 Parameter Number = 1 SQL Type = 0x7fff9c89e15e Param Def = 0x7fff9c89e154 Scale = 0x7fff9c89e15c Nullable = 0x7fff9c89e15a[ODBC][26251][SQLDescribeParam.c][276]Error: IM001[ODBC][26251][SQLBindParameter.c][193] Entry: Statement = 0x2b73c849fb80 Param Number = 1 Param Type = 1 C Type = 1 SQL_C_CHAR SQL Type = -1 SQL_LONGVARCHAR Col Def = 4000 Scale = 5 Rgb Value = http://stackoverflow.com/questions/3828215/0x2b73c941f890 Value Max = 0 StrLen Or Ind = 0x2b73c93fa1b0[ODBC][26251][SQLBindParameter.c][339] Exit:[SQL_SUCCESS]\[/code\]My understanding of the log is that unixODBC is trying to bind the parameters using the right type. But the FreeTDS doesn't support the function (IM001 is 'Driver does not support this function'). So unixODBC continue without proper typing.Can someone confirm this diagnosis or, better, a known issue with typed bound parameter in FreeTDS ? If yes, do they work using PHP PDO and hwo can I configure it ?
- RedHat Enterprise Linux 5
- PHP 5.2.14 with PDO and PDO_ODBC
- unixODBC 2.2.11
- FreeTDS 0.82.1.dev.20100810
foo, :bar');$stmt->bindValue(':foo', 21, PDO:ARAM_INT);$stmt->bindValue(':bar', 42, PDO:ARAM_INT);$stmt->execute():if (!$stmt->execute()) { var_dump($stmt->errorInfo();}\[/code\]Where both columns are INT. I get the an "206 [FreeTDS][SQL Server]Operand type clash: text is incompatible with int [SQLSTATE=22018]" error.In the unixODBC log, I get something like\[code\][ODBC][26251][SQLDescribeParam.c][175] Entry: Statement = 0x2b73c849fb80 Parameter Number = 1 SQL Type = 0x7fff9c89e15e Param Def = 0x7fff9c89e154 Scale = 0x7fff9c89e15c Nullable = 0x7fff9c89e15a[ODBC][26251][SQLDescribeParam.c][276]Error: IM001[ODBC][26251][SQLBindParameter.c][193] Entry: Statement = 0x2b73c849fb80 Param Number = 1 Param Type = 1 C Type = 1 SQL_C_CHAR SQL Type = -1 SQL_LONGVARCHAR Col Def = 4000 Scale = 5 Rgb Value = http://stackoverflow.com/questions/3828215/0x2b73c941f890 Value Max = 0 StrLen Or Ind = 0x2b73c93fa1b0[ODBC][26251][SQLBindParameter.c][339] Exit:[SQL_SUCCESS]\[/code\]My understanding of the log is that unixODBC is trying to bind the parameters using the right type. But the FreeTDS doesn't support the function (IM001 is 'Driver does not support this function'). So unixODBC continue without proper typing.Can someone confirm this diagnosis or, better, a known issue with typed bound parameter in FreeTDS ? If yes, do they work using PHP PDO and hwo can I configure it ?