How do I check the character set of an Oracle database?

6 months ago

1 minute

To check the character set of an Oracle database, you can execute the following command: 1. Login to SQL*Plus or SQL Developer of the Oracle database. 2. Use the command below to check the character set of the database:

SELECT value
FROM nls_database_parameters
WHERE parameter='NLS_CHARACTERSET';

This will return the character set name of the database. Additionally, you can also use the following command to view the database’s character set setting:

SHOW PARAMETER NLS_CHARACTERSET;

This will display the character set settings in the current session.