MS SQL Server problem
| From: | Mark Virtue | 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.