Oracle inserts data garbled to solve the problem. __oracle

1. See what character set is inside Oracle data server

Select userenv (' language ') from dual;

Or:

Select name, value$ from props$;

2. Switch to a system user using an Oracle command or service to execute a command: Export Nls_lang=american_america. ZHS16GBK,

Note: This local set of Nls_lang values is a subset of the Oracle's character set that is queried above or something else, such as:

The character set inside the Oracle server is American_america. ZHS16GBK, then the Nls_lang you set is

American_america. Zhs16gbk