What is the process for using tables with nvarchar fields in SQL Server?
Here's what we saw:
If I copy the table and replace all the nvarchar with varchar, that table displays. The table with nvarchar throws : "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."
Solution is at http://stackoverflow.com/questions/5414890/mssql-query-issue-in-php-and-querying-text-data - Critical lines are :
tds version = 8.0
client charset = UTF-8