This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This page discusses what was added in each version of the Microsoft Drivers for PHP for SQL Server.
Download Microsoft Drivers for PHP for SQL Server (Windows)
GitHub Release Tag v5.12.0 (Linux and macOS packages are available here)
| New item | Details |
|---|---|
| Added support for PHP 8.3. | |
| Removed support for PHP 8.0. | |
| Removed support for Ubuntu 18.04. | |
| Fixed invalid precision error for varchar. |
Download Microsoft Drivers for PHP for SQL Server (Windows)
GitHub Release Tag v5.11.1 (Linux and macOS packages are available here)
| New item | Details |
|---|---|
| Reset type after bind param. | |
| Fixed error when using PDO::ATTR_STRINGIFY_FETCHES. | |
| Change connection options to case insensitive. | |
| Bugfix for 1465 Adding a NULL check. |
Download Microsoft Drivers for PHP for SQL Server (Windows)
GitHub Release Tag v5.11.0 (Linux and macOS packages are available here)
| New item |
|---|
| Added support for PHP 8.2. |
| Dropped support for PHP 7.4. |
| Dropped support for Debian 9, macOS 10.15, and Alpine 3.13. |
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
| New item | Details |
|---|---|
| Added support for PHP 8.1. | |
| Dropped support for PHP 7.3. | |
| Dropped support for macOS Mojave, Ubuntu 16.04, Alpine 3.11 and 3.12. | |
| Added support for Windows 11 and Windows Server 2022. | |
| Added support for macOS Monterey, Debian 11, Ubuntu 21.04 and 21.10, Alpine 3.13, 3.14 and 3.15. | |
| Added support for Apple M1 ARM64 hardware. | Requires ODBC Driver 17.8 or above. |
| Added support for Table-valued Parameters. | |
| Allowed setting PDO::ATTR_EMULATE_PREPARES at the connection level. | |
| Adjusted connection keyword and value validation for more flexibility. |
1 This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute will occur. This warning may be suppressed when using an older ODBC driver. If using SQLSRV, check How to: Configure Error and Warning Handling Using the SQLSRV Driver. If using PDO_SQLSRV, warnings are by default suppressed but can be logged. Check Logging Activity for details.
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
| New item | Details |
|---|---|
| Added support for PHP 8.0. | |
| Dropped support for PHP 7.2. | |
| Added support for Microsoft ODBC Driver 17.7 on all platforms. | |
| Added support for macOS Big Sur, Ubuntu 20.04, Ubuntu 20.10 and Alpine 3.12. | Some require ODBC Driver 17.5 or above. |
| Dropped support for macOS High Sierra, Debian 8, and Ubuntu 19.10. | |
| Support for GB18030 locale. | |
Extended PDO errorinfo to include additional ODBC messages if available. |
|
| Support for Data Classification with rank info. | Requires SQL Server 2019 and ODBC Driver 17.4.2 or above. |
| Added Azure Active Directory Service Principal authentication support. | Requires ODBC Driver 17.7 or above. |
| Improved performance when handling decimal numbers as inputs or outputs and removed unnecessary conversions for numeric values. | |
| Improved performance when fetching numbers using client buffers. | |
| Set query timeout without using LOCK TIMEOUT, which saves an extra trip to the server. |
1 This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute will occur. This warning may be suppressed when using an older ODBC driver. If using SQLSRV, check How to: Configure Error and Warning Handling Using the SQLSRV Driver. If using PDO_SQLSRV, warnings are by default suppressed but can be logged. Check Logging Activity for details.
This release only applies to Linux and macOS.
GitHub Release Tag (Linux and macOS packages are available here)
| 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. |
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
| 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.
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
| 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. |
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
| 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. |
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)
Download Windows Package
GitHub Release Tag
Download Windows Package
GitHub Release Tag
Download Windows Package
GitHub Release Tag
In version 2.0, support for the PDO_SQLSRV driver was added. For more information, see PDO_SQLSRV Driver Reference.
Training
Module
Introduction to SQL Server 2022 T-SQL enhancements - Training
SQL Server 2022 introduces a range of new features and enhancements, providing powerful tools and capabilities that optimize performance and offer better control on SQL objects manipulation and creation.