Plsql Chinese garbled code
First, through
select userenv('language') from dual;
SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252
Query the oracle server-side code, such as: SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252 Set whatever code is displayed
The coding on our client side needs to be consistent with that on the server side.
Therefore, on the client side, you need to set the environment variable: NLS_LANG = SIMPLE CHINESE_CHINA.WE8MSWIN1252.
LANG=zh_CN.GBK
NLS_LANG="SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252"