Technote Details :: Cannot create Insert or Update forms for NTEXT fields

I have an Insert and Update transaction that work on fields of type NTEXT and NVARCHAR. When executing the transaction, I get an error 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.

I am using PHP.

This happens because PHP cannot work with UNICODE fields.

There is no solution to this issue yet. To have the insert and update forms work correctly you must modify the field types in the database, as follows:

• Replace NTEXT with TEXT
• Replace NVARCHAR with VARCHAR.