Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to query database version and character set

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report