Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 104 of 188


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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index