Checking Oracle Database Encoding
This returns the sort and comparison settings of the oracle db. Should be the same (BINARY)
SELECT * FROM nls_session_parameters WHERE parameter IN ('NLS_COMP', 'NLS_SORT'); SELECT * FROM nls_database_parameters WHERE parameter IN ('NLS_COMP', 'NLS_SORT'); SELECT SYS_CONTEXT('USERENV','NLS_SORT') nls_sort FROM DUAL;Returns the collation of the database, Expected value is `AL32UTF8`
SELECT * FROM nls_session_parameters WHERE PARAMETER='NLS_CHARACTERSET'; SELECT * FROM nls_database_parameters WHERE PARAMETER='NLS_CHARACTERSET';
最終更新日 2014 年 9 月 9 日
Powered by Confluence and Scroll Viewport.