The MSSQL Extension for PHP is build with an old version of Microsoft's DBLIB. This library does not support unicode, and it never will !!!
Use ODBC for now, and in a later version of PHP you can use a version of the MSSQL extension build with FreeTDS. This will enable unicode. This is now available on *nix systems but not on Win32 (I'm working on it). - Frank > 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.... > > > > -- > 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