Thursday, August 21, 2008

NLS_LANG diagnostics

select parameter, value from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');

echo $NLS_LANG

# run csscan to check for issues when export/import between databases with different characterset

CSSCAN SYSTEM/MANAGER FULL=y TOCHAR=AL32UTF8 ARRAY=102400 PROCESS=3