我在用
Python 2.7
cx_Oracle 6.0.2
我在我的代码中做了类似的事情
import cx_Oracle
connection_string = "%s:%s/%s" % ("192.168.8.168", "1521", "xe")
connection = cx_Oracle.connect("system", "oracle", connection_string)
cur = connection.cursor()
print "Connection Version: {}".format(connection.version)
query = "select *from product_information"
cur.execute(query)
result = cur.fetchone()
print result
我得到这样的输出
连接版本:11.2.0.2.0
(1,你'????????????','测试')
我正在使用以下查询在 oracle 数据库中创建表
CREATE TABLE product_information
( product_id NUMBER(6)
, product_name NVARCHAR2(100)
, product_description VARCHAR2(1000));
我使用以下查询来插入数据
insert into product_information values(2, 'दुःख', 'teting');
Edit 1
Query: SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');
Result
NLS_LANGUAGE:美国,NLS_TERRITORY:美国,NLS_CHARACTERSET:
AL32UTF8