Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?
A.
NLS_SORT = BINARY
B.
NLS_SORT = BINARY_AI
C.
NLS_SORT = BINARY_CI
D.
NLS_SORT = BINARY_AI_CI
E.
Binary sorts are case insensitive and accent insensitive by default.
Accent-insensitive binary sort:
NLS_SORT=BINARY_AI
case-insensitive sort:
NLS_SORT=BINARY_CI
Additonal information:
“Binary sorts can also be case-insensitive or accent-insensitive. When you specify BINARY_CI as a value for NLS_SORT, it designates a sort that is accent-sensitive and case-insensitive. BINARY_AI designates an accent-insensitive and case-insensitive binary sort.”