How to check nls_characterset parameter of database Oracle 18 August 202018 August 2020 Administrator SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’; VALUE$ WE8ISO8859P1 SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_NCHAR_CHARACTERSET’; VALUE$ AL16UTF16 Share this post: on Twitter on Facebook on Google+ Post Views: 475