Get the App
SLTechnology News&Howtos  ›  Database  › 

Plsql Chinese garbled code

Shulou Source: shulou.com Published: 2022-06-01 16:11:46 11月17日 Update

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"

Tags: Coding client client server end service consistency variable environment query garbled Chinese Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info NVidia Shulou Information Microsoft Xiaomi