PHP reads mssql ntext field return value is empty solution, mssqlntext_PHP tutorial

The solution to the problem that php reads the ntext field of mssql and returns an empty value, mssqlntext

The example in this article describes the solution to the problem that the ntext field returned by PHP when reading mssql is empty. Share it with everyone for your reference. The specific analysis is as follows:

Today when I used php to connect to the mssql database, I found that the content of the ntext field could not be displayed. After querying, I found that the ntext field is not supported in php. The solution is that we only need to change the ntext field to text.

If there is no ntext field in the table, you can use the following code:

Copy code The code is as follows:

// Connect to MSSQL
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'dsc');

if(!$link || !mssql_select_db('php', $link))
{
die('Unable to connect or select database!');
}

// Do a simple query, select the version of
// MSSQL and print it.
$version = mssql_query('SELECT @@VERSION');
$row = mssql_fetch_array($version);

echo $row[0];

// Clean up
mssql_free_result($version);
?>

If there is an ntext field in the table and it is difficult to modify it back to the text field, you can do the following:

1. Modify php.ini, open php.ini and find the following code:

;mssql.textlimit = 4096 changed to mssql.textlimit = 2147483647

Found:;mssql.textsize = 4096 changed to mssql.textsize = 2147483647

2. You can use modified fields. Since ntext and nvarchar fields in SQL Server use Unicode encoding to store content, PHP will report an error when reading fields with ntext and nvarchar types through mssql extension.

If the title field type is nvarchar and the content field type is ntext, then the following SQL statement will report an error.

The wrong code is as follows: select title, content from article

Correct:

select convert(varchar(255), title) as title, convert(text, content) as content from article

3. If you are a virtual host, you can use the adodb component to read. If your host does not support it, there is currently nothing I can do. The code is as follows:

Copy code The code is as follows:

include("adodb/adodb.inc.php"); //Include adodb class library file
$conn=NewADOConnection('odbc_mssql'); //Connect to SQL Server database
$conn->Connect("Driver={SQL Server};Server=localhost;
Database=mydb;",'username','password');
?>

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/935493.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/935493.htmlTechArticleThe solution to the problem that the ntext field return value of php when reading mssql is empty, mssqlntext This article tells the example of php reading mssql The ntext field returns a null solution. Share it with everyone for your reference...