note 15378 added to ref.mssql

From: 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

« previous php.notes (#17763) next »