Hi, At this stage you can not use the MSSQL extension to read datatypes ntext, nchar and nvarchar from a MSSQL server.
This is caused by an outdated version of DBLIB from Microsoft. This library has not been updated since SQL Server 6.0. The fix for now is to use ODBC or COM to communicate with ADODB. - Frank > code: > <? > include "config.inc.php"; > $query = "select * from book"; > $linkid = mssql_connect($dbhost,$dbuser,$dbpass); > $selectdb = mssql_select_db($db,$linkid); > $result = mssql_query($query); > ?> > but errors occur: > > Warning: MS SQL message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in f:\web\a.php on line 6 > > Warning: MS SQL: Query failed in f:\web\a.php on line 6 > > i've tried my best to solve this problem,but i failed. > can anyone help me?thanks. > i'm sorry to say,i'm poor in English,i don't know wheather you can understand me. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
