我想从输出fi中删除u

Question

我有python生成的输出

(u'PK_LampFactoryTest',)
(u'DF__Thermosta__Enabl__7B264821',)
(u'filestream_tombstone_2073058421',)
(u'RetentionSettings',)
(u'Alarms',)
(u'syscommittab',)

sqlquery = 'SELECT NAME FROM sys.objects' cursor.execute(sqlquery)

    #conn.commit()
    for row in cursor:
        print(row)

Answer 1

试试看：

import json, ast

for row in cursor:
    print(ast.literal_eval(json.dumps(row)))

Answer 2

u只是表示它是unicode。 一个简单的解决办法是

for row in cursor:
     print(row.encode('ascii', 'ignore'))

但这并不了解代码的全局，只会使print语句看起来更漂亮（通过对字符串进行编码）