Home > Database > Oracle > How to query the character set in oracle

How to query the character set in oracle

藏色散人
Release: 2021-12-15 11:40:47
Original
44834 people have browsed it

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.

How to query the character set in oracle

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;--服务端
Copy after login

##2. Client encoding

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

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template