Problem when quering a view in MSSQL 2000: 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)
| From: | Richard Gelderman | Date: | Wed, 12 Mar 2003 13:46:54 +0000 |
| Subject: | Problem when quering a view in MSSQL 2000: 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) |
||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18981@lists.php.net to get a copy of this message | ||
Hi there,
The following problem occurs when using a query who triggers its information
from a view in MSSQL 2000.
The errormessage that is returned:
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)
And yes, i'm using Unicode datafield. Strangly I can insert records in a
view without any errormessage.
I'm using IIS 5 on Windows 2000 Server and PHP 4.3.1.....very normal
configuration.
If anyone has a sollution for this problem I would be very pleased.
Thanks for reading this....