Converting Data Types

Download PHP driver

The Microsoft Drivers for PHP for SQL Server allows you to specify data types when you send data to or retrieve data from SQL Server. Specifying data types is optional. If data types are not specified, default types are used. The topics in this section describe how to specify data types and provide details about default data types.

In This Section

Topic Description
Default SQL Server Data Types Provides information about the default SQL Server data types when sending data to the server.
Default PHP Data Types Provides information about the default PHP data types when retrieving data from the server.
How to: Specify SQL Server Data Types Demonstrates how to specify SQL Server data types when sending data to the server.
How to: Specify PHP Data Types Demonstrates how to specify PHP data types when retrieving data from the server.
How to: Send and Retrieve UTF-8 Data Using Built-In UTF-8 Support Demonstrates how to use Microsoft Drivers for PHP for SQL Server's built-in support for UTF-8 data.

Support for UTF-8 characters was added in version 1.1 of the Microsoft Drivers for PHP for SQL Server.
How to: Send and Retrieve ASCII Data in Linux and macOS Demonstrates how to use Microsoft Drivers for PHP for SQL Server's support for ASCII data in Linux or macOS.

Support for ASCII characters in non-Windows environments was added in version 5.2 of the Microsoft Drivers for PHP for SQL Server.

See Also

Programming Guide for the Microsoft Drivers for PHP for SQL Server

SQLSRV Driver API Reference

Constants (Microsoft Drivers for PHP for SQL Server)

Example Application (SQLSRV Driver)