Skip to content

Latest commit

 

History

History
39 lines (31 loc) · 3.08 KB

File metadata and controls

39 lines (31 loc) · 3.08 KB
title Converting data types
description Learn how to specify data types and provide details about default data types when using the Microsoft Drivers for PHP for SQL Server
ms.custom
ms.date 08/10/2020
ms.prod sql
ms.prod_service connectivity
ms.reviewer
ms.technology connectivity
ms.topic conceptual
ms.assetid 508542ec-cc28-4a17-80f4-52325d6a48db
author David-Engel
ms.author v-daenge

Converting Data Types

[!INCLUDEDriver_PHP_Download]

The [!INCLUDEssDriverPHP] allows you to specify data types when you send data to or retrieve data from [!INCLUDEssNoVersion]. 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssDriverPHP]'s built-in support for UTF-8 data.

Support for UTF-8 characters was added in version 1.1 of the [!INCLUDEssDriverPHP].
How to: Send and Retrieve ASCII Data in Linux and macOS Demonstrates how to use [!INCLUDEssDriverPHP]'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 [!INCLUDEssDriverPHP].

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)