microsoft/msphpsql 4.0.8-Linux

Production Release for the PHP Linux Driver for SQL Server

on GitHub

We are excited to announce that production release of Linux drivers is available for Ubuntu 15.04, Ubuntu 16.04, and RedHat 7. Here is the list of updates:

Added

• Added SQLSRV_ATTR_FETCHES_NUMERIC_TYPE attribute support in PDO_SQLSRV driver.SQLSRV_ATTR_FETCHES_NUMERIC_TYPE connection attribute flag handles numeric fetches from columns with numeric Sql types (only bit, integer, smallint, tinyint, float and real). This flag can be turned on by setting its value in PDO::setAttribute to true, For example,
  $conn->setAttribute(PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE,true);
  If SQLSRV_ATTR_FETCHES_NUMERIC_TYPE is set to true the results from an integer column will be represented as an int, likewise, Sql types float and real will be represented as float.
  Note for exceptions:
  • When connection option flag ATTR_STRINGIFY_FETCHES is on, even when SQLSRV_ATTR_FETCHES_NUMERIC_TYPE is on, the return value will still be string.
  • When the returned PDO type in bind column is PDO_PARAM_INT, the return value from a integer column will be int even if SQLSRV_ATTR_FETCHES_NUMERIC_TYPE is off.
• Added Unicode Column name support(issue #138).

Fixed

• Fixed issue with SQLSRV_ATTR_FETCHES_NUMERIC_TYPE when column return type is set on statement (issue #173).
• Fixed precision issues when double data type returned as strings using buffered queries in PDO_SQLSRV driver.
• Fixed issue with buffered cursor in PDO_SQLSRV driver when CharacterSet is UTF-8 (issue #192).
• Fixed segmentation fault in error cases when error message is returned with emulate prepare attribute is set to true in PDO_SQLSRV driver.
• Fixed issue with empty output parameters on stored procedure(issue #182).
• Fixed memory leaks in buffered queries.

Limitations & Known issues

• This release contains the PHP 7 port of the SQLSRV and PDO_SQLSRV drivers on Linux, and does not provide backwards compatibility with PHP 5.
• Connection using named instances using '' is not supported.
• Local encodings other than UTF-8 are not supported, and SQLSRV_ENC_CHAR only supports ASCII characters with ASCII code of 0 to 127.
• Connection pooling in PDO_SQLSRV is not supported.
• Binary column binding with emulate prepare (issue#140)

Thanks,
SQL Server Team