Plsql Chinese garbled problem solution

1. View server-side encoding

A Select Userenv (' language ') from dual;

b The result I actually found was: American_america. Zhs16gbk

2, execute the statement select * frm v$nls_parameters;

A See if the nls_language in the parameter item in the first row corresponds to the same value in the first step.

b If it is not the same, you need to set the environment variable, otherwise the Plsql client uses the same encoding and server encoding, when inserting Chinese will appear garbled.

3. Setting Environment variables

A Computer à property à advanced system settings à environment variable à new

b Set variable named Nls_lang, variable value: The first step to find the value of my: American_america. Zhs16gbk

4, restart the plsql, insert data Normal

Plsql Chinese garbled problem solution