[edit] Last updated: Fri, 10 Feb 2012

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.

MSSQL_ASSOC (integer): Return an associative array. Used on mssql_fetch_array()'s result_type parameter.
MSSQL_NUM (integer): Return an array with numeric keys. Used on mssql_fetch_array()'s result_type parameter.
MSSQL_BOTH (integer): Return an array with both numeric keys and keys with their field name. This is the default value for mssql_fetch_array()'s result_type parameter.
SQLTEXT (integer): Indicates the 'TEXT' type in MSSQL, used by mssql_bind()'s type parameter.
SQLVARCHAR (integer): Indicates the 'VARCHAR' type in MSSQL, used by mssql_bind()'s type parameter.
SQLCHAR (integer): Indicates the 'CHAR' type in MSSQL, used by mssql_bind()'s type parameter.
SQLINT1 (integer): Represents one byte, with a range of -128 to 127.
SQLINT2 (integer): Represents two bytes, with a range of -32768 to 32767.
SQLINT4 (integer): Represents four bytes, with a range of -2147483648 to 2147483647.
SQLBIT (integer): Indicates the 'BIT' type in MSSQL, used by mssql_bind()'s type parameter.
SQLFLT4 (integer): Represents an four byte float.
SQLFLT8 (integer): Represents an eight byte float.

add a note User Contributed Notes Predefined Constants

plee61 at hotmail dot com 03-May-2008 10:32


SQLINT1 represents one byte, range -128 to 127 

SQLINT2 represents two bytes, range -32768 to 32767

SQLINT4 represents four bytes, range -2147483648 to 2147483647

add a note