How to check the Oracle database character set

In this tutorial, How do I use to check the Oracle query Database character set? Use “NLS_CHARACTERSET” and “NLS_NCHAR_CHARACTERSET” in the Oracle database.

Check the Oracle database character set

SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE from database_properties WHERE PROPERTY_NAME ='NLS_CHARACTERSET';

The screen output terminal

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ --------------
NLS_CHARACTERSET               AL32UTF8
SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE from database_properties WHERE PROPERTY_NAME ='NLS_NCHAR_CHARACTERSET';

The screen output terminal

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ --------------
NLS_NCHAR_CHARACTERSET         AL16UTF16

Conclusion

Through the article, you can “Check the Oracle database character set” as above. I hope will this your helpful. Thank you for reading the DevopsRoles page!

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published.

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.