PHP, MS SQL, ntext field problem 1

[xtreme69]

The error I get is:

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.

This error occurs when running any SELECT query that attempts to pull an ntext field. I am using the mssql functions in PHP to do so. Any help/ideas would be appreciated, thanks.

 

[jpadie]

i think this is a problem with odbs.

workaround: cast the field as a text field in your query

ie select cast(field2 as text) as field2 from table

 

[xtreme69]

Great! Thanks so much for that jpadie, I have spent a bunch of time searching the web for a solution, and this appears to be working perfectly. An extremely simple solution as well, which is bonus. Thanks again.