Folks,
I'd like to use MSSQL's capability for generating decent XML from databases. I'd like to do:
<?php
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");
$query = "select f1, f2, f3, f4 from mytable for xml auto";
?>
However, I keep getting an error message:
Warning: MS SQL 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:\Program Files\Apache Group...\connect1.php on line 13
Anyone ever accomplish this?
Danny
