Predefined Constants
The constants below are defined by this extension, and
will only be available when the extension has either
been compiled into PHP or dynamically loaded at runtime.
-
SQLSRV_FETCH_ASSOC
(integer)
-
Forces sqlsrv_fetch_array() to return an associative
array when passed as a parameter.
-
SQLSRV_FETCH_NUMERIC
(integer)
-
Forces sqlsrv_fetch_array() to return an array with
numeric when passed as a parameter.
-
SQLSRV_FETCH_BOTH
(integer)
-
Forces sqlsrv_fetch_array() to return an array with both
associative and numeric keys when passed as a parameter (the default behavior).
-
SQLSRV_ERR_ALL
(integer)
-
Forces sqlsrv_errors() to return both errors and warings
when passed as a parameter (the default behavior).
-
SQLSRV_ERR_ERRORS
(integer)
-
Forces sqlsrv_errors() to return errors only (no warnings)
when passed as a parameter.
-
SQLSRV_ERR_WARNINGS
(integer)
-
Forces sqlsrv_errors() to return warnings only (no errors)
when passed as a parameter.
-
SQLSRV_LOG_SYSTEM_ALL
(integer)
-
Turns on logging of all subsystems when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SYSTEM_CONN
(integer)
-
Turns on logging of connection activity when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SYSTEM_INIT
(integer)
-
Turns on logging of initialization activity when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SYSTEM_OFF
(integer)
-
Turns off logging of all subsystems when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SYSTEM_STMT
(integer)
-
Turns on logging of statement activity when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SYSTEM_UTIL
(integer)
-
Turns on logging of error function activity when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SEVERITY_ALL
(integer)
-
Specifies that errors, warnings, and notices will be logged
when passed to sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SEVERITY_ERROR
(integer)
-
Specifies that errors will be logged when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SEVERITY_NOTICE
(integer)
-
Specifies that notices will be logged when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_LOG_SEVERITY_WARNING
(integer)
-
Specifies that warnings will be logged when passed to
sqlsrv_configure() as a parameter.
-
SQLSRV_NULLABLE_YES
(integer)
-
Indicates that a column is nullable.
-
SQLSRV_NULLABLE_NO
(integer)
-
Indicates that a column is not nullable.
-
SQLSRV_NULLABLE_UNKNOWN
(integer)
-
Indicates that it is not known if a column is nullable.
-
SQLSRV_PARAM_IN
(integer)
-
Indicates an input parameter when passed to sqlsrv_query()
or sqlsrv_prepare().
-
SQLSRV_PARAM_INOUT
(integer)
-
Indicates a bidirectional parameter when passed to sqlsrv_query()
or sqlsrv_prepare().
-
SQLSRV_PARAM_OUT
(integer)
-
Indicates an output parameter when passed to sqlsrv_query() or
sqlsrv_prepare().
-
SQLSRV_PHPTYPE_INT
(integer)
-
Specifies an integer PHP data type. For usage information, see
» How to: Specify PHP Types.
-
SQLSRV_PHPTYPE_DATETIME
(integer)
-
Specifies a datetime PHP data type. For usage information, see
» How to: Specify PHP Types.
-
SQLSRV_PHPTYPE_FLOAT
(integer)
-
Specifies a float PHP data type. For usage information, see
» How to: Specify PHP Types.
-
SQLSRV_PHPTYPE_STREAM
(integer)
-
Specifies a PHP stream. This constant works like a function and accepts an
encoding constant. See the SQLSRV_ENC_* constants. For usage information, see
» How to: Specify PHP Types.
-
SQLSRV_PHPTYPE_STRING
(integer)
-
Specifies a string PHP data type. This constant works like a function and
accepts an encoding constant. See the SQLSRV_ENC_* constants. For usage information,
see » How to: Specify PHP Types.
-
SQLSRV_ENC_BINARY
(integer)
-
Specifies that data is returned as a raw byte stream from the server without
performing encoding or translation. For usage information, see
» How to: Specify PHP Types.
-
SQLSRV_ENC_CHAR
(integer)
-
Data is returned in 8-bit characters as specified in the code page of the
Windows locale that is set on the system. Any multi-byte characters or characters
that do not map into this code page are substituted with a single byte question
mark (?) character. This is the default encoding. For usage information,
see » How to: Specify PHP Types.
-
UTF-8
(integer)
-
Specifies that data is returned with UTF-8 encoding. For usage information,
see » How to: Specify PHP Types.
-
SQLSRV_SQLTYPE_BIGINT
(integer)
-
Describes the bigint SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_BINARY
(integer)
-
Describes the binary SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_BIT
(integer)
-
Describes the bit SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_CHAR
(integer)
-
Describes the char SQL Server data type. This constant works like a function
and accepts a parameter indicating the number characters. For usage information,
see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_DATE
(integer)
-
Describes the date SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_DATETIME
(integer)
-
Describes the datetime SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_DATETIME2
(integer)
-
Describes the datetime2 SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_DATETIMEOFFSET
(integer)
-
Describes the datetimeoffset SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_DECIMAL
(integer)
-
Describes the decimal SQL Server data type. This constant works like a function
and accepts two parameters indicating (in order) precision and scale. For usage information,
see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_FLOAT
(integer)
-
Describes the float SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_IMAGE
(integer)
-
Describes the image SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_INT
(integer)
-
Describes the int SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_MONEY
(integer)
-
Describes the money SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_NCHAR
(integer)
-
Describes the nchar SQL Server data type. This constant works like a function
and accepts a single parameter indicating the character count. For usage information,
see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_NUMERIC
(integer)
-
Describes the numeric SQL Server data type. This constant works like a function
and accepts two parameter indicating (in order) precision and scale. For usage
information, see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_NVARCHAR
(integer)
-
Describes the nvarchar SQL Server data type. This constant works like a function
and accepts a single parameter indicating the character count. For usage
information, see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_NVARCHAR
('max')
(integer)
-
Describes the nvarchar(MAX) SQL Server data type. For usage information,
see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_NTEXT
(integer)
-
Describes the ntext SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_REAL
(integer)
-
Describes the real SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_SMALLDATETIME
(integer)
-
Describes the smalldatetime SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_SMALLINT
(integer)
-
Describes the smallint SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_SMALLMONEY
(integer)
-
Describes the smallmoney SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_TEXT
(integer)
-
Describes the text SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_TIME
(integer)
-
Describes the time SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_TIMESTAMP
(integer)
-
Describes the timestamp SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_TINYINT
(integer)
-
Describes the tinyint SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_UNIQUEIDENTIFIER
(integer)
-
Describes the uniqueidentifier SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_UDT
(integer)
-
Describes the UDT SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_VARBINARY
(integer)
-
Describes the varbinary SQL Server data type. This constant works like a function
and accepts a single parameter indicating the byte count. For usage information,
see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_VARBINARY
('max')
(integer)
-
Describes the varbinary(MAX) SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_VARCHAR
(integer)
-
Describes the varchar SQL Server data type. This constant works like a function
and accepts a single parameter indicating the character count. For usage information,
see » How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_VARCHAR
('max')
(integer)
-
Describes the varchar(MAX) SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_SQLTYPE_XML
(integer)
-
Describes the XML SQL Server data type. For usage information, see
» How to: Specify SQL Types.
-
SQLSRV_TXN_READ_UNCOMMITTED
(integer)
-
Indicates a transaction isolation level of READ UNCOMMITTED. This value is
used to set the TransactionIsolation level in the $connectionOptions array
passed to sqlsrv_connect().
-
SQLSRV_TXN_READ_COMMITTED
(integer)
-
Indicates a transaction isolation level of READ COMMITTED. This value is
used to set the TransactionIsolation level in the $connectionOptions array
passed to sqlsrv_connect().
-
SQLSRV_TXN_REPEATABLE_READ
(integer)
-
Indicates a transaction isolation level of REPEATABLE READ. This value is
used to set the TransactionIsolation level in the $connectionOptions array
passed to sqlsrv_connect().
-
SQLSRV_TXN_SNAPSHOT
(integer)
-
Indicates a transaction isolation level of SNAPSHOT. This value is used to
set the TransactionIsolation level in the $connectionOptions array passed
to sqlsrv_connect().
-
SQLSRV_TXN_READ_SERIALIZABLE
(integer)
-
Indicates a transaction isolation level of SERIALIZABLE. This value is used
to set the TransactionIsolation level in the $connectionOptions array passed
to sqlsrv_connect().
-
SQLSRV_CURSOR_FORWARD
(integer)
-
Indicates a forward-only cursor. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_CURSOR_STATIC
(integer)
-
Indicates a static cursor. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_CURSOR_DYNAMIC
(integer)
-
Indicates a dynamic cursor. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_CURSOR_KEYSET
(integer)
-
Indicates a keyset cursor. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_CURSOR_BUFFERED
(integer)
-
Creates a client-side cursor query. Lets you access rows in any order. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_SCROLL_NEXT
(integer)
-
Specifies which row to select in a result set. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_SCROLL_PRIOR
(integer)
-
Specifies which row to select in a result set. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_SCROLL_FIRST
(integer)
-
Specifies which row to select in a result set. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_SCROLL_LAST
(integer)
-
Specifies which row to select in a result set. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_SCROLL_ABSOLUTE
(integer)
-
Specifies which row to select in a result set. For usage information, see
» Specifying a Cursor Type and Selecting Rows.
-
SQLSRV_SCROLL_RELATIVE
(integer)
-
Specifies which row to select in a result set. For usage information, see
» Specifying a Cursor Type and Selecting Rows.