[jordan]

WARNING, this could be a long post as I am going to attempt to put everything in here...

I have searched and still cannot get a resolution for this error relating to using php5 and mssql driver;

PHP Warning: mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: 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 <file>


the sql query has been trimmed down to;

select cast((fname + ' ' + lname) as text) as name from user for xml auto

Note that the casting was done due to some reference to ntext not being supported and this was a supposed fix for the error.


and the php code for the call is:

function altLoadData()
{

if(defined('DB_DEBUG') && DB_DEBUG == 1)
error_log(__FUNCTION__ . " Attempting to connect '" . DB_HOSTNAME . "' to use database '" . DB_DATABASE . "'");

if($this->sql_statement == NULL)
{
error_log(__FUNCTION__ . " sql statement is NULL");
return false;
}


$db = mssql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWORD) ;
$d = mssql_select_db(DB_DATABASE, $db);

$res = mssql_query($this->sql_statement, $db);

$row = mssql_fetch_array($res);
$this->sql_result = $row[0];


if(defined('DB_DEBUG') && DB_DEBUG == 1)
error_log(__FUNCTION__ . " RESULT'" . $this->sql_result . "'");

if( !$this->sql_result )
{
if(defined('DB_DEBUG') && DB_DEBUG == 1)
error_log(__FUNCTION__ . " Failed attempting to execute '" . $this->sql_statement . "'");

return false;
}

if(defined('DB_DEBUG') && DB_DEBUG == 1)
error_log(__FUNCTION__ . " SQL result '" . $this->sql_result. "'");

$this->bIsModified = false;
return true;

}
Most notable code is bolded above and now the big question, has anyone ran into this before? I haven't seen many references to php and the FOR XML AUTO stuff out there. As well there seems to be a fix available in Microsoft land (ASP, .net) and java land that is in the connetion string setting selectMethod=direct vs. SelectMethod=cursor. is there a window to be able to do this in php?

thanks in advance for any help as I know this can be a lot to digest
Jordan