首页 > 代码库 > PLSQL DEVELOPER 提示(错误)信息是乱码;亲测有效

PLSQL DEVELOPER 提示(错误)信息是乱码;亲测有效

新建两个本地环境变量:

LANG=zh_CN.GBK

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

注:

oracle的字符集:

select * from v$nls_parameters;

 

NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
3 NLS_CURRENCY ¥
4 NLS_ISO_CURRENCY CHINA
5 NLS_NUMERIC_CHARACTERS .,
6 NLS_CALENDAR GREGORIAN
7 NLS_DATE_FORMAT DD-MON-RR
8 NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET AL32UTF8

即:

系统环境变量 NLS_LANG 设置为: NLS_LANG = language_territory.charset