In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-27 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
The editor will share with you how to query the database version and character set. I hope you will get something after reading this article. Let's discuss it together.
The most important parameter that affects the character set of the Oracle database is the NLS_LANG parameter.
It has the following format: NLS_LANG = language_territory.charset
Such as: AMERICAN_AMERICA.ZHS16GBK
How to check the database version select * from v$version
Select * from v$version contains version information, core version information, digit information (32-bit or 64-bit), etc.
As for digit information, on the Linux/unix platform, it can be viewed through file, such as file $ORACLE_HOME/bin/oracle
View the database character set select * from nls_database_parameters
The database server character set select * from nls_database_parameters, which comes from props$, is the character set that represents the database.
Client character set environment select * from nls_instance_parameters, which comes from v$parameter
A setting that represents the character set of the client, which may be a parameter file, an environment variable, or a registry
The session character set environment select * from nls_session_parameters, which is derived from v$nls_parameters and represents the session's own settings
It may be the environment variable of the session or the alter session completion, which will be consistent with the nls_instance_parameters if the session has no special settings.
The character set of the client needs to be the same as that of the server in order to display the non-Ascii characters of the database correctly. If multiple settings exist, alter session > environment variables > registry > parameter file
The character set is required to be consistent, but the language setting can be different, and the language setting is recommended in English. If the character set is zhs16gbk, nls_lang can be American_America.zhs16gbk.
After reading this article, I believe you have a certain understanding of "how to query the database version and character set". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.