python报(‘HY000‘, ‘[HY000] [DataDirect][ODBC Sybase Wire Protocol driver]String data code

  1. 使用pypyodbc执行result=cur.fetchmany()查询时,抛出(‘HY000’, ‘[HY000] [DataDirect][ODBC Sybase Wire Protocol driver]String data code page conversion failed. Error in column 4.’)
    根据String data code page conversion failed猜想到可能是字符集问题,如将dsn的字符集进行修正,和sybase的数据库字符集保持一致。如图:
    python报(‘HY000‘, ‘[HY000] [DataDirect][ODBC Sybase Wire Protocol driver]String data code
  2. 修改后执行成功python报(‘HY000‘, ‘[HY000] [DataDirect][ODBC Sybase Wire Protocol driver]String data code