python cx_Oracle os.environ[‘NLS_LANG‘] = ‘SIMPLIFIED CHINESE_CHINA.UTF8‘

最新推荐文章于 2021-05-08 00:12:35 发布

scan724

最新推荐文章于 2021-05-08 00:12:35 发布

阅读量4.4k

点赞数

分类专栏： python cx_oracle

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/83269994

版权

python cx_oracle 专栏收录该内容

12 篇文章 ¥39.90 ¥99.00

订阅专栏

本文介绍如何在Python中使用cx_Oracle库连接Oracle数据库时，通过os.environ设置NLS_LANG环境变量为'SIMPLIFIED CHINESE_CHINA.UTF8'，以解决字符集问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

# !/usr/bin/env python
# -*- coding: utf-8 -*-
import cx_Oracle
from pprint import pprint
import csv
import time
import re
import binascii
print time.ctime()
try:
 conn = cx_Oracle.connect('tlcbuser/xx@10x.232/tlyy')
# cursor = conn.cursor()
# xsql="select * from tlcb_mon_device a where a.ipaddr='10.3.244.1'"
# r = cursor.execute(xsql)
# print r
except Exception,e:
 print e
 print type(e)
 print str(e).decode('UTF-8').encode('GBK')
 print time.ctime()
 
 
 C:\Python27\python.exe C:/Users/tlcb/PycharmProjects/untitled/a6.py
Mon Oct 22 10:35:59 2018
ORA-12170: TNS: ���ӳ�ʱ
<class 'cx_Oracle.DatabaseError'>
Mon Oct 22 10:36:20 2018

Process finished with exit code 0

了解本专栏