Friday, October 2, 2009

How To Find Your Characterset in Oracle

Got a request today from an application owner asking what NLS characterset we are using in our Oracle database (10g). Just ran the following simple query to find out:

select * from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET';