--- title: "Release Notes for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs" ms.custom: "" ms.date: "04/15/2020" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "v-dapugl, kenvh" ms.technology: connectivity ms.topic: conceptual helpviewer_keywords: - "what's new in version 1.1" ms.assetid: 91cca3d2-ba99-4a6d-b0de-beb9699cb3f8 author: David-Engel ms.author: v-daenge --- # Release Notes for the Microsoft Drivers for PHP for SQL Server This page discusses what was added in each version of the [!INCLUDE[ssDriverPHP](../../includes/ssdriverphp_md.md)]. ## 5.8.1 This release only applies to Linux and macOS. [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.8.1) ### Version information - Release number: 5.8.1 - Released: April 15, 2020 ## What's new in 5.8.1 | New item | Details | | :------- | :------ | | Bug fix | Fixed default locale issues in Alpine Linux. | | Bug fix | Removed unnecessary data structure to support Client-Side Cursors feature in Alpine Linux. | | Bug fix | Fixed logging issues when both drivers are enabled in Alpine Linux. | |   |   | ## 5.8 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120362) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.8.0) ### Version information - Release number: 5.8.0 - Released: January 31, 2020 ## What's new in 5.8 | New item | Details | | :------- | :------ | | Added support for PHP 7.4. |   | | Dropped support for PHP 7.1. |   | | Added support for Microsoft ODBC Driver 17.5 on all platforms. |   | | Added support for Debian 10 and Red Hat 8. | Both require ODBC Driver 17.4 or above. | | Added support for macOS Catalina, Alpine Linux 3.111 and Ubuntu 19.10. | All require ODBC Driver 17.5 or above. | | Dropped support for SQL Server 2008 R2, macOS Sierra, Ubuntu 18.10 and Ubuntu 19.04. |   | | Support for Language option when connecting to SQL Server. |   | | Support for PHP extended string types introduced in PHP 7.2. |   | | Support for Data Classification sensitivity metadata retrieval. | Requires SQL Server 2019 and ODBC Driver 17.4.2 or above. | | Support for Always Encrypted with secure enclaves. | Requires ODBC Driver 17.4 or above. | | Support configurable options for locale settings in Linux and macOS. | | Improved performance by caching metadata on fetches and omitting redundant calls. |   | |   |   | 1 Alpine Linux support is experimental for version 5.8. ## Previous releases ## 5.6.1 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120446) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.6.1) ### Version information - Release number: 5.6.1 - Released: March 19, 2019 ## What's new in 5.6.1 | New item | Details | | :------- | :------ | | Bug fix | Fixed assumptions made when calculating field or column metadata which may have resulted in application termination. | | Bug fix | Modified sqlsrv config file such that it can be compiled independently of pdo_sqlsrv. | | Bug fix | Fixed PDOStatement::getColumnMeta() to return false when something goes wrong. | |   |   | ## 5.6 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120450) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.6.0) ### Version information - Release number: 5.6.0 - Released: February 21, 2019 ## What's new in 5.6 | New item | Details | | :------- | :------ | | Support for PHP 7.3. |   | | Dropped support for PHP 7.0. |   | | Support for Microsoft ODBC Driver 17.3 on all platforms. |   | | Support for macOS Mojave. | Requires ODBC Driver 17.3 or above. | | Support for Ubuntu 18.10 and Suse Linux 15. | Both require ODBC Driver 17.3 or above. | | Dropped support for Linux Ubuntu 17.10 and macOS El Capitan. |   | | Support for Azure AD Access Token. | In Linux and macOS, requires ODBC Driver 17.2+ and unixODBC 2.3.6+. | | Support for Authentication with Azure AD using Managed Identity for Azure Resources. | Requires ODBC Driver 17.3+. | | New fetch functionalities | •   New PDO::SQLSRV_ATTR_FETCHES_DATETIME_TYPE flag for pdo_sqlsrv to return datetime as objects.

•   Add ReturnDatesAsStrings option to statement level for sqlsrv.

•   New options at connection and statement levels for both drivers for formatting decimal values in the fetched results. | | Support for static compilation of drivers if users choose to build from source. |   | | Improved performance by caching metadata on fetches and speeding up Unicode string conversions. |   | |   |   | ## 5.3 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120447) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.3.0) ### Version information - Release number: 5.3.0 - Released: July 20, 2018 ## What's new in 5.3 - Support for Microsoft ODBC Driver 17.2 on all platforms - Support for macOS High Sierra (requires ODBC Driver 17 and above) - Support for Azure Key Vault for Always Encrypted for basic CRUD functionalities such that Always Encrypted feature is available to all supported Windows, Linux or macOS platforms [Using Always Encrypted with the PHP Drivers for SQL Server](../../connect/php/using-always-encrypted-php-drivers.md) - Support Ubuntu 18.04 LTS (requires ODBC Driver 17.2) - Support for Connection Resiliency in Linux or macOS as well (requires ODBC Driver 17.2) ## 5.2 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120451) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.2.0) ### Version information - Release number: 5.2.0 - Released: March 23, 2018 ## What's new in 5.2 - Support for PHP 7.2.1 and up on Windows, and 7.2.0 and up on other platforms - Support for Microsoft ODBC Driver 17 - Version 17 is now the default on all platforms - Support for Ubuntu 17.10, Debian 9, and Suse Enterprise Linux 12 - Dropped support for Ubuntu 15.10 - Support for Always Encrypted with CRUD functionalities on Windows. For more information, see [Using Always Encrypted with the PHP Drivers for SQL Server](../../connect/php/using-always-encrypted-php-drivers.md) - Support for Windows Certificate Store - Always Encrypted is only supported with Microsoft ODBC Driver 17 and above - Support for non-UTF8 locales on Linux and macOS - Non-UTF8 locales on Linux and macOS are only supported with Microsoft ODBC Driver 17 and above - Support for Azure SQL Data Warehouse - Support for Azure SQL Managed Instance ## 4.3 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120616) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v4.3.0) ### Version information - Release number: 4.3.0 - Released: July 6, 2017 ## What's new in 4.3 - Support for PHP 7.1 - Support for macOS Sierra and macOS El Capitan - Support for Ubuntu 15.10, and Debian 8 - Dropped support for Ubuntu 15.04 - Support for Always On Availability groups via Transparent Network IP Resolution. For more information, see [Connection Options](../../connect/php/connection-options.md). - Added support for sql_variant data type with limitation. - Idle Connection Resiliency support in Windows. For more information, see [Connection Options](../../connect/php/connection-options.md). - Connection pooling support for Linux and macOS. For more information, see [Connection Pooling](../../connect/php/connection-pooling-microsoft-drivers-for-php-for-sql-server.md). - Support for Azure Active Directory Authentication with ActiveDirectoryPassword and SqlPassword. For more information, see [Connection Options](../../connect/php/connection-options.md). ## 4.0 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120448) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/microsoft/msphpsql/releases/tag/v4.0-RTW) ### Version information - Release number: 4.0 - Released: July 1, 2016 ## What's new in 4.0 - Support for PHP 7.0 - Full 64-bit support - Support for Ubuntu 15.04, Ubuntu 16.04, and RedHat 7 ## 3.2 ![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2120449) [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/microsoft/msphpsql/releases/tag/v3.2.0.0) ### Version information - Release number: 3.2 - Released: March 9, 2015 ## What's new in 3.2 - Support for PHP 5.6 - Includes latest updates for prior PHP versions 5.5 and 5.4 - Requires Microsoft ODBC Driver 11 for SQL Server ## 3.1 [GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/microsoft/msphpsql/releases/tag/v3.1.0.0) ### Version information - Release number: 3.1 - Released: December 12, 2014 ## What's new in 3.1 - Support for PHP 5.5 - Requires Microsoft ODBC Driver 11 for SQL Server. Previous versions required SQL Native Client. ## What's new in 3.0 - Support for PHP 5.4. PHP 5.2 is not supported in version 3 of the [!INCLUDE[ssDriverPHP](../../includes/ssdriverphp_md.md)]. - AttachDBFileName connection option is added. For more information, see [Connection Options](../../connect/php/connection-options.md). - Support for LocalDB, which was added in [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)]. For more information, see [Support for LocalDB](../../connect/php/php-driver-for-sql-server-support-for-localdb.md). - AttachDBFileName connection option is added. For more information, see [Connection Options](../../connect/php/connection-options.md). - Support for the high-availability, disaster recovery features. For more information, see [Support for High Availability, Disaster Recovery](../../connect/php/php-driver-for-sql-server-support-for-high-availability-disaster-recovery.md). - Support for client-side cursors (caching a result set in-memory). For more information, see [Cursor Types (SQLSRV Driver)](../../connect/php/cursor-types-sqlsrv-driver.md) and [Cursor Types (PDO_SQLSRV Driver)](../../connect/php/cursor-types-pdo-sqlsrv-driver.md). - The PDO::ATTR_EMULATE_PREPARES attribute has been added. For more information, see [PDO::prepare](../../connect/php/pdo-prepare.md). ## What's new in 2.0 In version 2.0, support for the PDO_SQLSRV driver was added. For more information, see [PDO_SQLSRV Driver Reference](../../connect/php/pdo-sqlsrv-driver-reference.md). ## See Also [Overview of the Microsoft Drivers for PHP for SQL Server](../../connect/php/overview-of-the-php-sql-driver.md)