fbpx

How to Check Oracle Database Character Set

time lapse photography of river

Many times you need to validate the Oracle database characterset, maybe because it is an old Oracle database that did not have UTF8 (which is the recommended charset) or maybe because someone created the database with a different charset for a given reason…

Anyways, here is how you can check the Oracle database characterset:

select *
from NLS_DATABASE_PARAMETERS
where parameter='NLS_CHARACTERSET';