Oracle Character Set modified to Utf-8__oracle

The character set and service side of the Oracle client are consistent, otherwise there will be garbled problems. changing the client character set

To connect to a server, you can query client settings:

SELECT * from V$nls_parameters;

Set Nls_lang = American_america in environment variable. UTF8 Changing the service-side character set

Through the sqlplus of the command window, log on with the system user, and then execute the following command:

>conn user name as SYSDBA;
>shutdown immediate; 
>startup Mount; 
>alter system enable restricted session;
>alter system set job_queue_processes=0;
>alter system set aq_tm_processes=0;
>alter database open;
>alter database character set UTF8;
or
>alter database character set Internal_use UTF8;
>shutdown immediate;
>startup;

At this point, whether it is sqlplus Insert query, or pl/sql insert query, will not appear garbled.