Solve Pl\sql garbled problem

View the character set of the database server

SELECT * from nls_database_parameters where parameter= ' nls_characterset ';

PARAMETER VALUE

Nls_characterset ZHS16GBK

Select Sys_context (' USERENV ', ' LANGUAGE ');

Client Character Set

SELECT * FROM Nls_instance_parameters

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/8C/DD/wKioL1h8ZxKAC1RGAAANUymf9UU013.png "title=" a.png "alt=" Wkiol1h8zxkac1rgaaanuymf9uu013.png "/>

Session Character Set

SELECT * FROM Nls_session_parameters

--if there is no special setting, it will be the same as Nls_instance_parameters

--The character set requires consistency, but the language settings can be different

--The character set is ZHS16GBK, then Nls_lang can be AMERICAN_AMERICA.ZHS16GBK

--1.echo%nls_lang%

-No return results

--2. Adding environment variables to Windows

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/8C/E1/wKiom1h8ZtPSYhKTAAAfmOckN8Q632.png "title=" q.png "alt=" Wkiom1h8ztpsyhktaaafmockn8q632.png "/>

Echo again

C:\users\yl>echo%nls_lang%

Simplified Chinese_china. Zhs16gbk

Re-login pl\sql, problem solving

This article from "Yangwang" blog, declined reprint!

Solve Pl\sql garbled problem