擅长:python、mysql、java
<p>如果您有旧的cx_Oracle模块,则在创建连接时需要指定字符集,例如:</p>
<pre><code>connection = cx_Oracle.connect("hr", userpwd, "dbhost.example.com/orclpdb1", encoding="UTF-8")
</code></pre>
<p>如果升级到cx_Oracle 8,则此字符集是默认字符集,因此可以省略<code>encoding</code>选项。见<a href="https://cx-oracle.readthedocs.io/en/latest/user_guide/globalization.html#setting-the-client-character-set" rel="nofollow noreferrer">Setting the Client Character Set</a></p>
<p>其他两项说明:</p>
<ul>
<li><p>计划升级到Python3,因为Python2已不再开发。Python3还改变了文本和字节的内部处理</p>
</li>
<li><p>希望您实际使用的是连接池,请参见<a href="https://blogs.oracle.com/opal/how-to-use-python-flask-with-oracle-database" rel="nofollow noreferrer">How to use Python Flask with Oracle Database</a></p>
</li>
</ul>