设置环境变量 重启PLSQL
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
原因:
客户端与服务器端编码不一致
了解下NLS_LANG的知识
NLS_LANG 参数组成NLS_LANG=_.
查看Oracle服务端编码:select * from sys.nls_database_parameters;
查看client编码:select * from sys.nls_session_parameters;
从下面服务端 编码我们可以得到: NLS_LANG = AMERICAN_AMERICA.AL32UTF8
查看oracle服务端编码:select * from sys.nls_database_parameters;
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR