('42000', '[42000] [FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data canno
来源：互联网 发布：军团要塞知乎 编辑：程序博客网 时间：2024/05/18 03:39
用pyodbc查询数据，windows执行成功，linux上报错
('42000', '[42000] [FreeTDS][SQL Server]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. (4004) (SQLExecDirectW)')
发现查询值的类型为 nvarchar(MAX)，将其转为nvarchar即可
另一个方法是freeTDS的升级
0 0
- ('42000', '[42000] [FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data canno
- mssql_query() unicode data in unicode-only
- Importing Excel data with SQL Server Integration Services and dealing with unicode and non-unicode data issues
- Building a Data Warehouse: With Examples in SQL Server
- Only Using the MDF File to Restore the Data Base in SQL SERVER 2005
- save the file in unicode format to prevent data loss.
- The text, ntext, and image data types are invalid in this subquery or aggregate expression.
- UNICODE, only?
- Managing Data Growth in SQL Server
- sql server unicode 支持
- 解决Python3.6，发送POST请求错误提示：POST data should be bytes, an iterable of bytes, or a file object. It canno
- Unicode字段也有collation?
- Unicode字段也有collation
- Data Binding: A godsend or the devil in disguise?
- Finding Initialized or Uninitialised static data in a DLL
- Building a Data Warehouse: With Examples in SQL Server (Hardcover), Dec.2007.eBook-BBL
- 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration a
- Python Serialize Unicode Data 处理BUG修正.
- spring的PreferencesPlaceholderConfigurer类对数据库密码进行加密
- J2EE系列之Hibernate4学习笔记（六）--Hibernate中对象的4种状态
- 美团面试
- MySQL
- 常见专业术语名词解释（持续更新）
- ('42000', '[42000] [FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data canno
- 设计模式（一）--单例模式
- 电子书
- 2017-5-11 C++primer笔记
- 3.6 JS日期函数 Date()
- U-Boot中关于TEXT_BASE，代码重定位，链接地址相关说明
- Row was updated or deleted by another transaction 异常原因及处理
- 2016年蓝桥杯决赛 奇怪的数列
- MFC getforeignground window
