title: Windows Collation in Oracle
body: <p>I am new SSIS and the package that i am building involves the use of Merge Join. Join is performed between a RAW File and Oracle Table. The <code>NLS_SORT</code> and <code>NLS_COMP</code> option for oracle database is <code>"BINARY"</code>. RAW File, by default picks up Windows Collation. What is the equivalent of Windows Collation in ORACLE? Will the above settings would work or some workaround is required, since i am not getting desired results from Merge Join. I had even used <code>SELECT.... ORDER BY NLSSORT(EmployeeName, 'BINARY_CI')</code>, but still getting wrong results. Do anyone have idea?</p>