pyodbc 通过cursor.description获取列名显示不全,这个有碰到过的吗?
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【GBase版本】:
【操作系统】:
【CPU】:
【问题描述】*:
表结构:create table tpyodbc(id serial, username varchar(60), usersex char(30), 描述 char(30));
连接信息:DRIVER=/home/gbase8s/lib/cli/iclis09b.so;SERVER=127.0.0.1,9088;DATABASE=test;UID=gbasedbt;PWD=Gbase@123;SERVERNAME=gbase01;CLIENT_LOCALE=zh_CN.utf8;DB_LOCALE=zh_CN.utf8;
执行查询:select * from tpyodbc;
打印cursor.description:
cursor.description:
(('i\x00', <class 'int'>, None, 10, 10, 0, False), ('u\x00s\x00e\x00r\x00', <class 'str'>, None, 60, 60, 0, True), ('u\x00s\x00e\x00r', <class 'str'>, None, 30, 30, 0, True), ('描\x00', <class 'str'>, None, 30, 30, 0, True))
column from cursor.description is:
colume1: i (type: <class 'int'>)
colume2: user (type: <class 'str'>)
colume3: user (type: <class 'str'>)
colume4: 描 (type: <class 'str'>)
这个列名只显示一半,有碰到过的大佬求解
评论
centos7.6 + python2.7 + libodbc.so.2.0.0 能用pyodbc==3.1.1;

python2.7 + pyodbc3.1.1 + libodbc.so.2.0.0
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25044
- 42023-09-25浏览数:18519
- 52020-05-11浏览数:17526
