同样的语句,通过oracledb查询返回结果总是有错误,与pl/sql返回结果不一致
const sql =
"select UTL_RAW.CAST_TO_RAW(t.JH) as jh, to_char(t.RQ) as RQ,to_char(t.RCYL) as RCYL,to_char(t.RCYL1) as RCYL1,to_char(t.SCSJ) as scsj from cyrb.dba01 t where t.jh='" +
jh +
"' and rownum <10 order by t.RQ desc ";
let result = await connection.execute(sql);
node-oracle返回结果
实际上最新的日期不是2020-11-05,是2022-09-02
而且有的语句返回的rows为空,实际不为空
以上是之前的提问,近期已找到问题原因,
主要是服务器端oracle的字符编码是us7ascii,所以在查询有中文的列,返回的肯定是空值
所以在使用oracledb时,如何解决服务器与客户端字符编码不一致问题?