NLS_COMP

Parameter type:	String
Syntax:	NLS_COMP = {BINARY | ANSI}
Parameter class:	Dynamic. Scope = ALTER SESSION.
Default value:	BINARY
Normally, comparisons in the WHERE clause of queries are binary unless you specify the NLSSORT function. By setting this parameter to ANSI, you indicate that comparisons in the WHERE clause of queries should use the linguistic sort specified in the NLS_SORT parameter. You must also define an index on the column for which you want linguistic sorts. See Also: Oracle8i National Language Support Guide for more information on setting this parameter.