mssql php 无法选择字段类型 nvarchar(MAX)


mssql php can't select field type nvarchar(MAX)

我使用此代码从sql server 2012 db中选择密码字段,并且不返回任何数据我尝试更改字段类型,它确实有效实际上我无法更改主服务器中的字段类型,我需要按原样使用它

知道如何解决它吗?

<?php
$objConnect = mssql_connect("localhost:1434'MSSQLSERVER","fdi","fdifdi");
if($objConnect)  
{  
echo "Database Connected.<br />";  
mssql_select_db('Intranett', $objConnect);
$query = mssql_query('SELECT  [pass] FROM [Intranett].[dbo].[v24Brukere]');
// Check if there were any records
if (!mssql_num_rows($query)) {
    echo 'No records found';
} else {
    // Print a nice list of users in the format of:
    // * name (username)
    echo '<ul>';
    while ($row = mssql_fetch_object($query)) {
        echo '<li>' . $row->pass .' </li>';
    }
    echo '</ul>';
}
}  
else  
{  
echo "Database Connect Failed.<br />";  
echo mssql_get_last_message();
}  
mssql_close($objConnect);  
?>  

我所知,旧的和长期过时的mssql驱动程序不支持NVARCHAR。您应该改用Microsoft的 SQL Server Driver for PHP。