select * from v$nls_parameters
看环境变量里的NLS_LANG配置
SIMPLIFIED CHINESE.ZHS16GBK
为正确配置
PARAMETER: NLS_LANGUAGE
VALUE: SIMPLIFIED CHINESE
PARAMETER: NLS_TERRITORY
VALUE: CHINA
PARAMETER: NLS_CURRENCY
VALUE: ¥
PARAMETER: NLS_ISO_CURRENCY
VALUE: CHINA
PARAMETER: NLS_NUMERIC_CHARACTERS
VALUE: .,
PARAMETER: NLS_CALENDAR
VALUE: GREGORIAN
PARAMETER: NLS_DATE_FORMAT
VALUE: DD-MON-RR
PARAMETER: NLS_DATE_LANGUAGE
VALUE: SIMPLIFIED CHINESE
PARAMETER: NLS_CHARACTERSET
VALUE: ZHS16GBK
PARAMETER: NLS_SORT
VALUE: BINARY
PARAMETER: NLS_TIME_FORMAT
VALUE: HH.MI.SSXFF AM
PARAMETER: NLS_TIMESTAMP_FORMAT
VALUE: DD-MON-RR HH.MI.SSXFF AM
PARAMETER: NLS_TIME_TZ_FORMAT
VALUE: HH.MI.SSXFF AM TZR
PARAMETER: NLS_TIMESTAMP_TZ_FORMAT
VALUE: DD-MON-RR HH.MI.SSXFF AM TZR
PARAMETER: NLS_DUAL_CURRENCY
VALUE: ¥
PARAMETER: NLS_NCHAR_CHARACTERSET
VALUE: AL16UTF16
PARAMETER: NLS_COMP
VALUE: BINARY
PARAMETER: NLS_LENGTH_SEMANTICS
VALUE: BYTE
PARAMETER: NLS_NCHAR_CONV_EXCP
VALUE: FALSE