MSSQL + PHP + FOR XML

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
NoReason
Forum Commoner
Posts: 51
Joined: Tue Sep 10, 2002 6:19 pm

MSSQL + PHP + FOR XML

Post by NoReason »

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.

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)
Post Reply