oracle_client_sample.py

#!/usr/bin/env python
import sys
import os 
import cx_Oracle

reload(sys)
sys.setdefaultencoding('utf-8')

os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.AL32UTF8' 

conn = cx_Oracle.connect('username/password@address:port/database')

cursor = conn.cursor()
cursor.execute('SELECT T.NICKNAME FROM T_SM_USER T  WHERE T.ID = 1')

row = cursor.fetchall()

print "%r" % row[0][0]
print row[0][0].decode("utf-8")

conn.close()