当前位置:网站首页>Solve the problem of database insert data garbled in PL / SQL developer

Solve the problem of database insert data garbled in PL / SQL developer

2020-11-06 01:23:30 itread01

I've been studying recently SSM Project development , be used oracle Database ,

Using management software PL/sql developer Record garbled code when inserting data into database table .

 

 

  The results are as follows :

You can see that the Chinese materials are all garbled ??????? Question mark ,

 

Read the solutions of the big guys on the Internet , It's because of oracle Server side character encoding and Oracle Client character encoding inconsistency caused by .

( But my oracle Server side and Oracle The client character encoding is the same , I wonder , But the same solution is used , Get it done !!!)

First step :

Log in PL/sql developer, Check Oracle Server side character encoding , use

 

select userenv('language') from dual;

The following results are obtained :

It turns out :

 

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

 

The second step :

Look at Oracle Client character encoding , use

 

select * from V$NLS_PARAMETERS;

 

The following results are obtained :

 

  You can see my oracle Server side and Oracle The client character encoding is the same , It doesn't matter. Keep looking down

 

 

 

The third step :

 

stay windows Zhongchuang Build one called “NLS_LANG” System environment variables of ,

Set the value to “SIMPLIFIED CHINESE_CHINA.ZHS16GBK”, Follow oracle Server side character encoding is consistent , And then restart pl/sql developer

 

 

  Can solve the problem of garbled code !!!

 

 

 

 

 

 

Add 1:( Problem solving can ignore the following )

After the students who have the same problem with me finish the above steps , Login again PL/Sql developer The data still shows garbled code .

Then the solution is :

Delete the table , Please delete the table , Instead of just deleting the data in the table ,

And then rebuild the watch , Re insert data , Find the problem and solve it !!!

Add 2: Because it's using idea Do development , So it's direct use idea in database Connect to the database , And then rebuild the watch , Insert data ,

Direct use PL/Sql developer Never tried , It should also be possible .

 

&n

版权声明
本文为[itread01]所创,转载请带上原文链接,感谢