How to query the character set in oracle

Oracle query character set method: 1. Execute "SELECT * FROM Nls_Database_Parameters;" to view the server encoding; 2. Execute "SELECT Userenv('language') FROM dual;" to view the client encoding.

The operating environment of this article: Windows 7 system, Dell G3 computer, Oracle 11g version.

How to query the character set in oracle?

Oracle character set view:

1. Server encoding

SELECT * FROM Nls_Database_Parameters;--服务端

##2. Client encoding

SELECT Userenv('language') FROM dual;--客户端

3. Modify the client character set to be consistent with the server

Right-click the computer-Properties-Advanced system settings- Advanced - Environment Variables - System Variables Add nls_lang American_America.us7ascii

Related recommendations:

oracle database learning tutorial

The above is the detailed content of How to query the character set in oracle. For more information, please follow other related articles on the PHP Chinese website!