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:
- Format Column: Column in the base table that identifies the format of the data: 'BINARY' or
'TEXT'. Allows INSO filtering to be bypassed for selected rows. interMedia Text examines the value in the format column: if this value is 'BINARY',
it sends the data through the INSO filter; if the value is 'TEXT', it bypasses
the INSO filter and sends the text straight through.
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.
- Charset column: Column in the base table that identifies the character set of the data. If
'TEXT' format documents are not all in the same character set or in the database
character set, this feature allows the INSO filter to do per-row character set
translation for such documents. The INSO filter first looks at Format Column. If its value is 'TEXT', the INSO filter examines Charset Column for the character set of the document. The document text is converted from
this character set to the database character set.
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:
- Language Column: The table column that identifies the language of the text in a row within a
multi-language document processed with a MULTI_LEXER type 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)