Index: Preference Columns

Note: These items can be specified only when you are creating a new index. You cannot specify or change them for an existing index; instead, you must create a new index (and first drop the existing one if necessary) and specify these items.

Inso Filter:

The format column must be in the same table as the text column, and it must be CHAR, VARCHAR, or VARCHAR2 type. The value is case-insensitive, so 'BINARY' and 'binary' are the same. If the column value is null or not 'BINARY' or 'TEXT', then the document is passed through the INSO filter.

The charset column must be in the same table as the text column, and it must be CHAR, VARCHAR, or VARCHAR2 type. The value is case-insensitive, but should be an NLS character set string. If the column value is null or is not recognized, then the document is passed through without any conversion.

Charset Column does not have to be specified when using the INSO filter. If Charset Column is specified and Format Column is not specified, then all documents are assumed to be text documents, and the INSO filter works like the CHARSET filter.

Multi Lexer:

Separate topics are available with information about MULTI_LEXER lexer attributes (NLS Language, Language Specific Lexer, Alternate Language Value ID) and how to use the MULTI_LEXER lexer.

Buttons (Apply, Revert, Show SQL/Hide SQL)

See also: Main topics (outline)