[ANNOUNCEMENT] sqlsrv-5.5.0preview (devel) Released.
| From: | PECL Announce | Date: | Fri, 07 Dec 2018 17:20:51 +0000 |
| Subject: | [ANNOUNCEMENT] sqlsrv-5.5.0preview (devel) Released. | ||
| Groups: | php.pecl.dev | ||
| Request: | Send a blank email to pecl-dev+get-15618@lists.php.net to get a copy of this message | ||
The new PECL package sqlsrv-5.5.0preview (devel) has been released at https://pecl.php.net/.
Release notes
-------------
[Added]
- Added support for PHP 7.3.0
- Added support for Linux Ubuntu 18.10 and mac OS Mojave
- Feature Request [#415](https://github.com/Microsoft/msphpsql/pull/886) - new options at connection
and statement levels for both drivers for formatting decimal values in the fetched results
[Fixed]
- Pull Request [#854](https://github.com/Microsoft/msphpsql/pull/854) - Clear Azure Key Vault data
after connection attributes are successfully set or when exception is thrown
- Pull Request [#855](https://github.com/Microsoft/msphpsql/pull/855) - Improved performance by
saving meta data before fetching and skipping unnecessary conversions for numeric data
- Pull Request [#865](https://github.com/Microsoft/msphpsql/pull/865) - Corrected the way SQLPutData
and SQLParamData are used when sending stream data to the server
- Pull Request [#878](https://github.com/Microsoft/msphpsql/pull/878) - Modified the config files to
enable Spectre Mitigations for PHP 7.1 (see related Request
[#836](https://github.com/Microsoft/msphpsql/pull/836))
- Pull Request [#891](https://github.com/Microsoft/msphpsql/pull/891) - Improved performance of
Unicode conversions
- Pull Request [#892](https://github.com/Microsoft/msphpsql/pull/892) - Removed warning messages
while compiling extensions
[Limitations]
- No support for inout / output params when using sql_variant type
- No support for inout / output params when formatting decimal values
- In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection.
Attempting to set the locale after connecting will not work
- Always Encrypted 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. Custom Keystores are not yet
supported
- Issue [#716](https://github.com/Microsoft/msphpsql/issues/716) - With Always Encrypted enabled,
named parameters in subqueries 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 is not recommended with [unixODBC](http://www.unixodbc.org/)
< 2.3.7
- When pooling is enabled in Linux or macOS
- unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic 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))
- With ColumnEncryption enabled, fetching varbinary(max), varchar(max) or nvarchar(max) may fail
with [ODBC Driver 17.3
CTP](https://blogs.msdn.microsoft.com/sqlnativeclient/2018/09/24/odbc-driver-17-3-preview-for-sql-server-released/)
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 SQLSRV driver.*
Related Links
-------------
Package home: https://pecl.php.net/package/sqlsrv
Changelog: https://pecl.php.net/package-changelog.php?package=sqlsrv
Download: https://pecl.php.net/get/sqlsrv-5.5.0preview.tgz
Authors
-------------
Meet Bhagdev <meetb@microsoft.com> (lead)
Jay Kint <jaykint@microsoft.com> (lead)
Marie Barwin (lead)
Jenny Tam (lead)