Why php can link to MSSQL but cannot read the table

Source: Internet
Author: User
After a long time today, we can clearly link to the database, but cannot read data. Google and Baidu finally learned that the reverse return value of the ntext field of mssql read by php is null. we recommend that you change the ntext field to text.

The reason may be: php's support for the ntext type of mssql;

After a long time today, we can clearly link to the database, but cannot read data. Google and Baidu finally learned that the reverse return value of the ntext field of mssql read by php is null. we recommend that you change the ntext field to text.

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


// Connect to MSSQL
$ Link = mssql_connect ('kallespc \ SQLEXPRESS ', 'sa', 'phpfi ');

If (! $ Link |! Mssql_select_db ('php', $ link ))
{
Die ('unable to connect or select database! ');
}

// Do a simple query, select the version
// MSSQL and print it.
$ Version = mssql_query ('select @ version ');
$ Row = mssql_fetch_array ($ version );

Echo $ row [0];

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

If the table contains an ntext military field and it is difficult to modify the text field, you can:

1. modify php. ini

Open php. ini

Find:

; Mssql. textlimit = 4096

Change

Mssql. textlimit = 2147483647

Find:

; Mssql. textsize = 4096

Change

Mssql. textsize = 2147483647

2. you can modify fieldsIn SQL server, ntext and nvarchar fields are stored in unicode encoding. Therefore, php uses mssql extension to read ntext and nvarchar fields with errors.

If the title field type is nvarchar and the content field type is ntext, the following SQL statement reports an error:

Incorrect:

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 VM, you can use the adodb component to read. If your host does not support it, I cannot do it now.


Include ("adodb/adodb. inc. php"); // contains the adodb class library file
$ Conn = NewADOConnection ('odbc _ mssql'); // connect to the SQL Server database
$ Conn-> Connect ("Driver = {SQL Server}; Server = localhost; Database = mydb;", 'username', 'password ');
?>

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.