Cx_oracle Read the Oracle database Chinese garbled problem solve

When using the Cx_oracle module to read Chinese records in the Oracle database, the return value is all, after Google has this good text, the problem is resolved, hereby remember.

The Oracle database version is 10g and the character set is Al32utf8.

The following sentences need to be added to the Python script you are writing:

Import os os.environ['nls_lang'simplified Chinese_china. UTF8'

This will ensure that the select out of Chinese display no problem.

To be able to normal insert and update Chinese, you also need to specify the Python source file character set encoding and Oracle consistency.

#

Cx_oracle Read the Oracle database Chinese garbled problem solve