提示错误
Warning: mssql_query() [function.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.
在网上找到3种解决方法
1:将所查询的字段 ntext类型的转化成text类型
2:改变查询语句 类似:SELECT CAST(field1 AS TEXT) AS field1 FROM table
3 : Open up your free tds configuration file (/etc/freetds.conf), and change: [global] tds version = 4.2 change to version = 8.0
试了第3种方法,结果把汉字都转成?了,不管用,最后用方法2,找到几个nvarchar的字段sql语句转换AS TEXT才解决问题。