MSSQL + PHP + FOR XML
Posted: Thu Oct 30, 2003 4:36 pm
It appears that the current mssqllib for php does not support unicode, ntext data. Has anyone else run into this problem before.??
I am using Select statements with the FOR XML clause, and it returns (i would asssume) the information in ntext datetype.. And no matter what i do i cannot cast or convert the returned data into an readable datatype that the current libs can handle.
I am using Select statements with the FOR XML clause, and it returns (i would asssume) the information in ntext datetype.. And no matter what i do i cannot cast or convert the returned data into an readable datatype that the current libs can handle.
Code: Select all
PHP Warning: 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)