Solve the problem of Oracle Chinese garbled code

The blogger's name is taken from 《 Shaun the Sheep 》 Shawn the lamb in the , The name is ： Sean , Transliterated as Sean, Take your own last name ： Archie , In order to conform to our reading habits , Connected to form ArchieSean. Bloggers aim to build blogs into a technology stack for personal online notes , Be convenient for yourself and others . If there are any mistakes in the blog , Please point out , Thank you. .

In recent days, , I'm playing Oracle when , Insert data into the database , Find out , In Chinese, it is shown as ？？？？？, To solve this problem , I run between websites , Seeking solutions , It was finally solved , Here is a summary of the solution process .

1. Use PL/SQL Perform the following sql, see Oracle Character set used

Select userenv('language') from dual;

2. Add the environment variable of the local computer

NLS_LANG
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

3. here , You need to delete the data in the following table , Reinsert data , Normal Chinese will be displayed

I made a mistake in revising , After I added the environment variable , The direct query has not changed , After I insert a new piece of data , The Chinese display of the newly queried data is normal , Delete the previous garbled data .

If there are any questions , Welcome to leave a message .