note 72035 added to function.mssql-query

When using this function on Linux with the FreeTDS dblib driver, some system stored procedures can return NULL values. This is because Microsoft SQL Server also uses a Windows-specific variant type in addition to the standard SQL types... like VB & OLE variants. For example: <?php // this works fine on Windows (using ntwdblib.dll) $r = mssql_query( 'SELECT SERVERPROPERTY(\'productversion\')' ); // but, you might want to do this instead (for Linux portability) $r = mssql_query( 'SELECT CAST(SERVERPROPERTY(\'productversion\') AS VARCHAR)' ); ?> ---- Server IP: 66.163.161.117 Probable Submitter: 63.214.184.6 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-query.php Edit -- https://master.php.net/note/edit/72035 Del: integrated -- https://master.php.net/note/delete/72035/integrated Del: useless -- https://master.php.net/note/delete/72035/useless Del: bad code -- https://master.php.net/note/delete/72035/bad+code Del: spam -- https://master.php.net/note/delete/72035/spam Del: non-english -- https://master.php.net/note/delete/72035/non-english Del: in docs -- https://master.php.net/note/delete/72035/in+docs Del: other reasons-- https://master.php.net/note/delete/72035 Reject -- https://master.php.net/note/reject/72035 Search -- https://master.php.net/manage/user-notes.php