How to check the Oracle database character set

In this tutorial, How do I use the Oracle query Database character set? Use “NLS_CHARACTERSET” and “NLS_NCHAR_CHARACTERSET” in 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

Thought the article, you can “Check the Oracle database character set” as above. I hope will this your helpful.

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. Required fields are marked *

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.