MS SQL Server problem

From: Date: Mon, 24 Feb 2003 06:16:59 +0000
Subject: MS SQL Server problem
Groups: php.general 
Request: Send a blank email to php-general+get-136835@lists.php.net to get a copy of this message
This code works perfectly and returns all the data that I expect: mssql_pconnect($hostname, $username, $password) or die("blah blah"); mssql_select_db($dbName) or die("blah blah"); $result = mssql_query("select MyFieldName from MyTable"); But if I change the last line to this: $result = mssql_query("select * from MyTable"); I get the following warnings and no result is returned: Warning: mssql_query() [function.mssql-query]: 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 c:\test.php on line 24 Warning: mssql_query() [function.mssql-query]: Query failed in c:\test.php on line 24 I am using 4.3.0 on WinXP. Any thoughts? Mark.

« previous php.general (#136835) next »