php查询SqlServer报错问题ntext data cannot be sent to clients using DB-Library
来源:互联网 发布:php竞价推广系统源码 编辑:程序博客网 时间:2024/05/24 06:41
提示错误
Warning:mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-onlycollation or ntext data cannot be sent to clients using DB-Library (such asISQL) 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才解决问题。
- php查询SqlServer报错问题ntext data cannot be sent to clients using DB-Library
- hmset命令报错 value sent to redis cannot be null
- 异常 报错 Android library projects cannot be launched
- android library projects cannot be launched 报错原因!
- SSH框架问题——node to traverse cannot be null!报错问题
- 执行hibernate报错“node to traverse cannot be null”问题的解决
- 执行hibernate报错“node to traverse cannot be null”问题的解决
- delphi中报Left side cannot be assigned to错
- [解决]cxf报错 ElementNSImpl cannot be cast to XXX
- Button cannot be resolved to a type报错
- 关于WebServlet cannot be resolved to a type报错
- 报错:BASE64Encoder cannot be resolved to a type
- XX cannot be resolved to a type 报错
- hibernate报错:JoinColumn cannot be resolved to a type
- 报错Test cannot be resolved to a type
- android library projects cannot be launched问题
- cannot modify header information - headers already sent by ,php页面报错debug
- PHP程序报错:Warning: Cannot modify header information - headers already sent的问题解决方法
- 同样的一辈子,不同的感受
- grep、sed与sort常用方法
- [转]零基础学Qt 4编程实例之四:理解并正确使用名字空间
- Java抓取网页 解析网页HtmlParser
- virtualbox下ubuntu与windows XP共享目录
- php查询SqlServer报错问题ntext data cannot be sent to clients using DB-Library
- JAVA程序员面试32问,你能回答多少题?
- Splash Screen开场屏在Android中的实现
- CSerialPort类接收数据时comstat未初始化
- 杜绝JAVA软件开发的五大误区
- VG mirror 和RAID1有区别吗
- 明勒姆
- 搭建基本的Java开发环境
- RFID与NFC的主要区别