内容简介：微软 SQL Server PHP 驱动 5.3.0 发布了，该驱动程序允许从 Linux、Windows 和 macOS 上的 PHP 7.0-7.2 应用程序访问 SQL Server、Azure SQL 数据库、Azure SQL 托管实例和 Azure SQL DW。 此次更新内容如下： Ad...
微软 SQL Server PHP 驱动 5.3.0 发布了，该驱动程序允许从 Linux 、Windows 和 macOS 上的 PHP 7.0-7.2 应用程序访问 SQL Server、Azure SQL 数据库、Azure SQL 托管实例和 Azure SQL DW。
此次更新内容如下：
Added
Added support for Azure Key Vault for Always Encrypted functionality. Always Encrypted functionality is supported on Linux and macOS through Azure Key Vault
Added support for connection resiliency on Linux and macOS (requires version 17.2 or higher of the ODBC driver)
Added support for macOS High Sierra (requires version 17 or higher of the ODBC driver)
Added support for Ubuntu 18.04 (requires version 17.2 or higher of the ODBC driver)
Fixed
Issue #577 - Idle Connection Resiliency doesn't work with Column Encryption enabled connections (fixed in MS ODBC Driver 17.1)
Issue #678 - Idle Connection Resiliency doesn't work with Connection Pooling (fixed in MS ODBC Driver 17.1)
Issue #699 - Binding output parameters fails when the query in the stored procedure returns no data. The test case has been added to the test lab.
Issue #705 - Always Encrypted - Retrieving a negative decimal value (edge case) as output parameter causes truncation
Issue #706 - Always Encrypted - Cannot insert double with precision and scale (38, 38)
Issue #707 - Always Encrypted - Fetching decimals / numerics as output parameters bound to PDO::PARAM_BOOL or PDO::PARAM_INT returns floats, not integers
Issue #735 - Extended the buffer size for PDO::lastInsertId so that data types other than integers can be supported
Pull Request #759 - Removed the limitation of binding a binary as inout param as PDO::PARAM_STR with SQLSRV_ENCODING_BINARY
Pull Request #775 - Fixed the truncation problem for output params with SQL types specified as SQLSRV_SQLTYPE_DECIMAL or SQLSRV_SQLTYPE_NUMERIC
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. Attempting to set the locale after connecting will not work
Always Encrypted requires MS ODBC Driver 17+
Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not supported
Issue #716 - With Always Encrypted enabled, named parameters in subqueries are not supported
Known Issues
Connection pooling on Linux or macOS is not recommended with unixODBC < 2.3.6
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
With ColumnEncryption enabled, calling stored procedures with XML parameters does not work (Issue #674)
下载地址：
【声明】文章转载自：开源中国社区 [http://www.oschina.net]
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持 码农网
猜你喜欢:
- 一个更快，数据类型支持更精准的 golang PostgreSQL 驱动
- OpenBSD 6.4 发布，添加许多新的驱动程序支持
- OpenBSD 6.4 发布，添加许多新的驱动程序支持
- RedisPlus 3.2.0 升级底层驱动，支持 SSH 秘钥连接
- SQL Server PHP 驱动 5.3.0 发布，支持 Ubuntu 18.04
- Golang的分布式锁组件，支持Reids，Pgsql或自定义驱动
本站部分资源来源于网络，本站转载出于传递更多信息之目的，版权归原作者或者来源机构所有，如转载稿涉及版权问题，请联系我们。
