Python Connection database-set Oracle, MySQL Chinese character issue

1 Importcx_oracle2 ImportMySQLdb3 4 defconn_oracle ():5CNN = Cx_oracle.connect (' User name','Password','IP: Port number/Database') //user name, password, IP port number database6Cur =cnn.cursor ()7     returnCnn,cur8 9 Ten defclose_oracle (cnn,cur): One cur.close () A cnn.close () -  - defconn_mysql (): theCNN = MySQLdb.connect (user="User name", passwd=' Password', host='localhost', db=' Database', charset='UTF8'user name, password, IP, database, character settings -Cur =cnn.cursor () -     returnCnn,cur -  + defClose_mysql (cnn,cur): - cur.close () +Cnn.close ()

NOTE: 1, Oracle sets the character set, assuming that there is a Chinese

Oracle Set character sets Import osos.environ['nls_lang'simplified Chinese_china. UTF8'

2. mysql setting character set charset= "

MySQLdb.connect (user=" username ", passwd=' password ', host=' localhost ', db=' database ', charset='UTF8'

Chinese characters are the most annoying in Python.

Python Connection database-set Oracle, MySQL Chinese character issue