cx_oracle插入中文乱码


需要同时设置Python中NLS_LANG的值,和bash中oracle的NLS_LANG的值

Python

import os
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'  

Bash

cd /home/oracle/ #这里要进入oracle用户的目录下
vi .bash_profile
    插入NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8";export NLS_LANG
source .bash_profile