The following new features have been added to Full-Text Search since version 12.0:
Supported data types – Adaptive Server introduces two new datatypes: unichar and univarchar. Enhanced Full-Text Search supports indexing of columns of these types.
Licensing – there is a new configuration option in Adaptive Server 12.5, which enables Full-Text Search capability. Additionally, a license is required to enable this capability. Enhanced Full-Text Search does not accept connections from an Adaptive Server that does not have this feature enabled. To enable Full-Text Search capability, enter:
sp_configure ‘enable full-text search’, 1
File system access – Adaptive Server 12.5 now allows mapping of proxy tables to files and directories. Enhanced Full-Text Search 12.5 supports indexing of columns of these tables.
High-availability – Enhanced Full-Text Search now supports the high-availability feature of Adaptive Server Enterprise. If an Adaptive Server fails, Enhanced Full-Text Search accepts connections from the companion server. If the Adaptive Server has proxy database support enabled, then both the primary and the companion servers can use Enhanced Full-Text Search at the same time.
batch_blocksize – a new configuration parameter enables the Full-Text Search engine to retrieve data in the specified chunk sizes of up to 64K.
sp_check_text_index – a new stored procedure you can use to report and fix consistency problems in the Full-Text Search index and source tables.
IDENTITY column size limit increased – in earlier Full-Text Search versions, the IDENTITY column of the source table was limited to 10 digits. This restriction has been removed to allow IDENTITY column precision up to numeric(38,0).
Named pipes – this version supports named pipes, where allowed by Adaptive Server Enterprise.
The highlighting feature is no longer supported.
