Type binding not properly managed in PDO

[microsoft]

Type binding not properly managed in PDO

[yitam]

Hi @david-garcia-garcia , to fetch numeric values as numbers rather than strings simply do this $conn->setAttribute( PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE, true);

Please confirm.

[meet-bhagdev]

@david-garcia-garcia : Does @yitam's recommendation help?

[yitam]

Hi @david-garcia-garcia

First and foremost, I believe the varbinary issue is already fixed by Pull Request #297. Please verify.

Moreover, for numeric types and buffered queries, I don't think the problem exists anymore. Here is my simple script:

$conn->exec("CREATE TABLE testTable (col1 int, col2 float, col3 real)"); 
$conn->setAttribute( PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE, true);

$stmt = $conn->prepare('INSERT INTO testTable VALUES (5, 0.57, 123.456)'); 
$stmt->execute(); 
        
$stmt = $conn->prepare("select * from testTable", array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL, PDO::SQLSRV_ATTR_CURSOR_SCROLL_TYPE => PDO::SQLSRV_CURSOR_BUFFERED));

if ($stmt->execute()){
     $row = $stmt->fetchObject();
     var_dump($row);
}

The output I got is

object(stdClass)#2 (3) {
  ["col1"]=>
  int(5)
  ["col2"]=>
  float(0.57)
  ["col3"]=>
  float(123.45600128174)
}

Without PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE set to true, I got output like this

object(stdClass)#2 (3) {
  ["col1"]=>
  string(1) "5"
  ["col2"]=>
  string(4) "0.57"
  ["col3"]=>
  string(7) "123.456"
}

Therefore, we will close this issue. Please feel free to reopen it if you still experience similar problems.