The new PECL package pdo_sqlsrv-5.2.1preview (devel) has been released at 
http://pecl.php.net/.

Release notes
-------------
[Added]
- Added support for Azure Key Vault for Always Encrypted for basic CRUD 
functionalities such that Always Encrypted feature is also available to Linux 
or macOS users 
- Added support for macOS High Sierra (requires [MS ODBC Driver 
17+](https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017))
[Fixed]
- Issue [#577](https://github.com/Microsoft/msphpsql/issues/577) - Idle 
Connection Resiliency doesn't work with Column Encryption enabled connection
- Issue [#678](https://github.com/Microsoft/msphpsql/issues/678) - Idle 
Connection Resiliency doesn't work with Connection Pooling bug
- Issue [#705](https://github.com/Microsoft/msphpsql/issues/705) - AE - 
Retrieving a negative decimal value (edge case) as output parameter causes 
truncation
- Issue [#706](https://github.com/Microsoft/msphpsql/issues/706) - AE - Cannot 
insert double with precision and scale (38, 38)
- Issue [#707](https://github.com/Microsoft/msphpsql/issues/707) - AE - 
Fetching decimals / numerics as output parameters bound to PDO::PARAM_BOOL or 
PDO::PARAM_INT returns floats, not integers 
- Issue [#735](https://github.com/Microsoft/msphpsql/issues/735) - Extended the 
buffer size for PDO lastInsertId such that data types other than integers can 
be supported
[Limitations]
- No support for inout / output params when using sql_variant type
- In Linux and macOS, setlocale() only takes effect if it is invoked before the 
first connection. The subsequent locale setting will not work
- Always Encrypted feature, which requires [MS ODBC Driver 
17+](https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017)
  - only Windows Certificate Store and Azure Key Vault are supported
  - Issue [#716](https://github.com/Microsoft/msphpsql/issues/716) - With 
Always Encrypted feature enabled, Named Parameters in Sub Queries are not 
supported
  - [Always Encrypted 
limitations](https://docs.microsoft.com/en-us/sql/connect/php/using-always-encrypted-php-drivers?view=sql-server-2017#limitations-of-the-php-drivers-when-using-always-encrypted)
[Known Issues]
- Connection pooling on Linux or macOS not recommended with 
[unixODBC](http://www.unixodbc.org/) < 2.3.6
- When pooling is enabled in Linux or macOS
  - unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostics 
information, such as error messages, warnings and informative messages
  - due to this unixODBC bug, fetch large data (such as xml, binary) as streams 
as a workaround. See the examples 
[here](https://github.com/Microsoft/msphpsql/wiki/Features#pooling)
- With ColumnEncryption enabled, calling stored procedure with XML parameter 
does not work (Issue [#674](https://github.com/Microsoft/msphpsql/issues/674))

Package Info
-------------
The Microsoft Drivers for PHP for SQL Server are PHP extensions that allow for 
the reading and writing of SQL Server data from within PHP scripts. The SQLSRV 
extension provides a procedural interface while the PDO_SQLSRV extension 
implements PDO for accessing data in all editions of SQL Server 2008 R2 and 
later (including Azure SQL DB). These drivers rely on the Microsoft ODBC Driver 
for SQL Server to handle the low-level communication with SQL Server.
*This package contains only the PDO_SQLSRV driver.*

Related Links
-------------
Package home: http://pecl.php.net/package/pdo_sqlsrv
   Changelog: http://pecl.php.net/package-changelog.php?package=pdo_sqlsrv
    Download: http://pecl.php.net/get/pdo_sqlsrv-5.2.1preview.tgz

Authors
-------------
Jay Kint <jayk...@microsoft.com> (lead)
Meet Bhagdev <me...@microsoft.com> (lead)
Marie Barwin (lead)
Jenny Tam (lead)


-- 
PECL development discussion Mailing List (http://pecl.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to