python3在oracle插入中文编码问题

正常读取

• 读取解决中文乱码，修改一下变量保持和oracle一致

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

• 查看oracle的NLS_LANG

select * from V$NLS_PARAMETERS;
select userenv(‘language’) from dual;

正常insert和update

• 需要修改os.py源文件：C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\Lib
• 把字符集变量加进去声明的下面就可以了
  

修改oracle编码的方法

sqlplus / as sysdba

方法一

UPDATE PROPS$ SET VALUE$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET';
shutdown immediate;
startup;

方法二

shutdown immediate;
startup mount;
alter session set sql_trace=true;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
alter database open;
alter database character set internal_use utf8;
shutdown immediate;
startup;