Please help suggesting a better method changing / converting the NLS_Characterset from WE8ISO8859P15 to WE8MSWIN1252.
The oracle instance on the development environment is setup as
NLS_CHARACTERSET WE8ISO8859P15
NLS_NCHAR_CHARACTERSET AL16UTF16
The oracle instance on the production environment is setup as
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
Many thanks.