How to check the character set of an Oracle database?

1 year ago
Jackson Davis
1 minute

You can check the character set of an Oracle database by following these steps:

  1. Log in to the Oracle database server.
  2. Open SQL*Plus or SQL development tool.
  3. Execute the following SQL statement:
SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';

This will return the character set information of the database.

Alternatively, you can execute the following SQL statement to view all supported character sets:

SELECT * FROM v$nls_valid_values WHERE parameter = 'CHARACTERSET';

This will return a list of all supported character sets.

bannerAds