Release Notes for the Microsoft Drivers for PHP for SQL Server

This page discusses what was added in each version of the Microsoft Drivers for PHP for SQL Server.

5.9

download Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

Version information

  • Release number: 5.9.01
  • Released: January 29, 2021

What's new in 5.9

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.

Previous releases

5.8.1

This release only applies to Linux and macOS.

GitHub Release Tag (Linux and macOS packages are available here)

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 Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

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.

5.6.1

download Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

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 Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

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 Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

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
  • 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 Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

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
    • 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 Synapse Analytics
  • Support for Azure SQL Managed Instance

4.3

download Download Windows Package
GitHub Release Tag (Linux and macOS packages are available here)

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.
  • Added support for sql_variant data type with limitation.
  • Idle Connection Resiliency support in Windows. For more information, see Connection Options.
  • Connection pooling support for Linux and macOS. For more information, see Connection Pooling.
  • Support for Azure Active Directory Authentication with ActiveDirectoryPassword and SqlPassword. For more information, see Connection Options.

4.0

download Download Windows Package
GitHub Release Tag

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 Red Hat 7

3.2

download Download Windows Package
GitHub Release Tag

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

download Download Windows Package
GitHub Release Tag

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.

3.0

download Download Windows Package

What's new in 3.0

2.0

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.

See Also

Overview of the Microsoft Drivers for PHP for SQL Server