Changing the Oracle Database Characterset
Hi,This is how you can change the character set of your Oracle DB. Checking the actual values: We want to change NLS_CHARACTERSET to WE8ISO8859P1 which is now WE8MSWIN1252. I checked again and:
Hi,This is how you can change the character set of your Oracle DB. Checking the actual values: We want to change NLS_CHARACTERSET to WE8ISO8859P1 which is now WE8MSWIN1252. I checked again and:
SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ; SELECT * FROM NLS_DATABASE_PARAMETERS select owner, table_name, column_name from dba_tab_columns where (data_type = ‘NCHAR’ or data_type = ‘NVARCHAR2’ or data_type = ‘NCLOB’) and owner != ‘SYS’ and owner != ‘SYSTEM’;