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.
