note 15378 added to ref.mssql
| From: | stuart at fourelephants dot com | Date: | Fri, 07 Sep 2001 09:31:50 +0000 |
| Subject: | note 15378 added to ref.mssql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-17763@lists.php.net to get a copy of this message | ||
Using the latest php 4 on MS2000 with IIS5. Whenever I try to query ntext data I get the following:
"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) "
a bit of research got me this answer:
"This is because SQL Programmer and ISQL both use the Microsoft library ntwdblib.dll to connect
to the database. Microsoft SQL Server 7.0 introduced three new Unicode data types, (NCHAR, NVARCHAR
and NTEXT) which cannot be sent to clients using DB-Library (such as ISQL) or ODBC Drivers prior to
version 3.70. The current version does not support these data types. "
But it doesn't really solve my problem. Does anyone have any pointers?
Thanks
Stuart
http://www.php.net/manual/en/ref.mssql.php