• python 打印数组中文显示为'xe6xb5x8bxe8xafx95xe4xb8xbbxe6x9cxba‘’


    # !/usr/bin/env python
    # -*- coding: utf-8 -*-
    import cx_Oracle
    from pprint import pprint
    import csv
    import time
    import re
    import binascii
    
    conn = cx_Oracle.connect('system/oracle@192.168.137.2/serv')
    cursor = conn.cursor()
    xsql='select * from tlcb_mon_device'
    r = cursor.execute(xsql)
    print r
    arr=[]
    for x in r:
        print x
        print x[0]
        print len(x[0])
        #print x[1]
        print x[1].decode('gbk').encode('utf-8')
        print len(x[1])
        y=x[1].decode('gbk').encode('utf-8')
        print len(y)
        print  type(x)
        arr.append(x[0])
        arr.append(y)
    print '-------------------------------------------------------------------------------------------------'
    print arr
    print type(arr)
    for x in arr:
        print x
    
    
    C:Python27python.exe C:/Users/TLCB/PycharmProjects/untitled/mycompany/Django/a21.py
    <cx_Oracle.Cursor on <cx_Oracle.Connection to system@192.168.137.2/serv>>
    ('192.168.137.3', 'xb2xe2xcaxd4xd6xf7xbbxfa')
    192.168.137.3
    13
    测试主机
    8
    12
    <type 'tuple'>
    ('192.168.137.4', 'xc9xfaxb2xfaxd6xf7xbbxfa')
    192.168.137.4
    13
    生产主机
    8
    12
    <type 'tuple'>
    -------------------------------------------------------------------------------------------------
    ['192.168.137.3', 'xe6xb5x8bxe8xafx95xe4xb8xbbxe6x9cxba', '192.168.137.4', 'xe7x94x9fxe4xbaxa7xe4xb8xbbxe6x9cxba']
    <type 'list'>
    192.168.137.3
    测试主机
    192.168.137.4
    生产主机
    
    Process finished with exit code 0
    
    
    
    python 显示为xe6xb5x8bxe8xafx95xe4xb8xbbxe6x9cxba,实际取出后正常。

  • 相关阅读:
    项目Alpha冲刺Day7
    项目Alpha冲刺Day5
    项目Alpha冲刺Day6
    Alpha冲刺总结
    测试随笔
    项目Alpha冲刺Day12
    高校征信系统项目Postmortem结果
    冲刺合集
    总结随笔
    测试工作安排
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13349489.html
Copyright © 2020-2023  润新知