Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | String |
Syntax | NLS_COMP = { BINARY | ANSI } |
Default value | BINARY |
Modifiable | ALTER SESSION |
Basic | No |
Normally, comparisons in the WHERE
clause and in PL/SQL blocks is binary unless you specify the NLSSORT
function. By setting NLS_COMP
to ANSI
, you indicate that comparisons in the WHERE
clause and in PL/SQL blocks 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: Oracle Database Globalization Support Guide for more information on setting this parameter |