为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。 【DM版本】:DM8 【操作系统】: 【CPU】: 【问题描述】*:DM8 字符集 UTF-8,ORACLE AL32UTF8 。执行select 查询时,其中一个字段报错,查询其他字段不报错。 第二个问题 查询中文时,乱码。 求助,如何解决!
CREATE OR REPLACE LINK LINK1 CONNECT 'ORACLE' WITH USER01 IDENTIFIED BY Oracle_123 USING (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.225)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl) ) (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) );
试一下这种方式看行不行比一般tns多一行(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
CREATE OR REPLACE LINK LINK1 CONNECT 'ORACLE' WITH USER01 IDENTIFIED BY Oracle_123 USING
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.225)(PORT =
1521)))
(CONNECT_DATA = (SERVICE_NAME = orcl) )
(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
);
试一下这种方式看行不行比一般tns多一行(NLS_LANG=AMERICAN_AMERICA.AL32UTF8)