How to Check Oracle Database Character Set

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 *
where parameter='NLS_CHARACTERSET';

Leave a Reply

Your email address will not be published. Required fields are marked *