php和mssql的类型转换

转自 http://ca3.php.net/mssql_execute:

if(!defined('dbMSSQL_Types'))

{

define('dbMSSqlTypes',1);

$MSSQL_types[127] = SQLINT4; /* bigint*/

$MSSQL_types[104] = SQLBIT; /* bit*/

$MSSQL_types[175] = SQLCHAR; /* char*/

$MSSQL_types[56] = SQLINT4; /* int*/

$MSSQL_types[52] = SQLINT2; /* smallint*/

$MSSQL_types[35] = SQLTEXT; /* text*/

$MSSQL_types[48] = SQLINT1; /* tinyint*/

$MSSQL_types[167] = SQLVARCHAR; /* varchar*/

$MSSQL_types[62] = SQLFLT8; /* float*/

$MSSQL_types[173] = SQLVARCHAR; /* binary*/ // Adaptation

$MSSQL_types[61] = SQLVARCHAR; /* datetime*/ // Adaptation

$MSSQL_types[106] = SQLFLT8; /* decimal*/ // Adaptation

$MSSQL_types[34] = SQLVARCHAR; /* image*/ // Adaptation

$MSSQL_types[60] = SQLFLT8; /* money*/ // Adaptation

$MSSQL_types[239] = SQLCHAR; /* nchar*/ // Adaptation

$MSSQL_types[99] = SQLTEXT; /* ntext*/ // Adaptation

$MSSQL_types[108] = SQLFLT8; /* numeric*/ // Adaptation

$MSSQL_types[231] = SQLVARCHAR; /* nvarchar*/ // Adaptation

$MSSQL_types[59] = SQLFLT8; /* real*/ // Adaptation

$MSSQL_types[58] = SQLINT4; /* smalldatetime*/ // Adaptation

$MSSQL_types[122] = SQLFLT8; /* smallmoney*/ // Adaptation

$MSSQL_types[98] = SQLVARCHAR; /* sql_variant*/ // Adaptation

$MSSQL_types[189] = SQLINT4; /* timestamp*/ // Adaptation

$MSSQL_types[165] = SQLVARCHAR; /* varbinary*/ // Adaptation

}