PHP using SQL database to get field problem Introduction _php tutorial

In the PB development process, due to the use of the database ntext field, the following prompt error, depressed for a long time to find a solution, after looking at a large amount of information, finally understand:
PB Error:You cannot use Db-library (such as ISQL) or ODBC 3.7 or earlier to send ntext data or Unicode data that uses only Unicode collation to the client.
————————————————
Because the ntext and nvarchar fields are stored in Unicode encoding in SQL Server, PHP reads the fields with ntext and nvarchar types through the MSSQL extension with a wrong hold.

If the Title field type is nvarchar,content field type ntext, then the following SQL statement will give an error:
Select Title,content from article

The correct wording is:
Select CONVERT (varchar (255), title) as title, convert (text,content) as content from article
Or do not use the ntext field
This is very useful to solve my problem!

http://www.bkjia.com/PHPjc/328178.html www.bkjia.com true http://www.bkjia.com/PHPjc/328178.html techarticle PB development process, due to the use of the database ntext field, the following prompt error, depressed for a long time to find a solution, after looking at a lot of information, finally understand: PB newspaper ...

