珀耳塞福建 发表于 2018-9-10 06:26:15

oracle终端sqlplus显示乱码问题

  sqlplus登陆oracle服务器查询表显示中文是?乱码
  SQL> select * from test11;
  ID
  ----------
  NAME
  --------------------------------------------------------------------------------
  111
  ??
  222
  ??
  333
  ??????
  SQL> select userenv('language') from dual;
  USERENV('LANGUAGE')
  ----------------------------------------------------
  AMERICAN_AMERICA.AL32UTF8
  $ export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
  SQL> insert into test11 values(334,'张东');
  1 row created.
  SQL> select * from test11;
  ID NAME
  ---------- --------------------
  334 张东
  111 肖明
  222 吴明
  333
  SQL> insert into test11 values(335,'吴敏');
  1 row created.
  SQL> select * from test11;
  ID NAME
  ---------- --------------------
  334 张东
  335 吴敏
  111 肖明
  222 吴明
  333

页: [1]
查看完整版本: oracle终端sqlplus显示乱码问题