Basic text search requirements and restrictions

When you plan how to configure basic text searching, you must understand the requirements and restrictions.

Database server requirement

The Scheduler must be running in the database server. If the Scheduler is not running when you create a bts index, a message that the access method is not found is returned.

Database requirements

The database that contains the bts index must be logged and must not be an ANSI database. If you attempt to create a bts index in an unlogged or ANSI database, the message DataBlade registration failed is printed in the database server message log.

Data type support

To use basic text searching, you must store the text data in a column of data type BLOB, BSON, CHAR, CLOB, JSON, LVARCHAR, NCHAR, NVARCHAR, or VARCHAR.

To use basic text searching, you must store the text data in a column of data type BLOB, CHAR, CLOB, LVARCHAR, NCHAR, NVARCHAR, or VARCHAR.

Although you can store searchable text in a column of the BLOB data type, you cannot create a basic text search index on binary data. BLOB data type columns must contain text.

Locales and languages support

Basic text search queries can use most multi-byte character sets and global language support, including UTF-8, and can use ideographic languages such as Chinese, Korean, and Japanese if you specify the CJK analyzer.

Important: If you use UTF-8 character encoding, including the Chinese GB18030-2000 code set, you must set the GL_USEGLU environment variable before you create the database.

JSON or BSON documents must be in a database with a UTF-8 locale.

High availability support

You can run basic text search queries on primary and all types of secondary servers in high-availability clusters.

Index characteristics restrictions
The following characteristics are not supported for bts indexes:
  • Fill factors
  • Index clustering
  • Unique indexes
Indexed document restrictions

If your documents are over 32 KB, store them in columns of type BLOB or CLOB.

The size of a document that you want to index is limited by the amount of available virtual memory on your machine. For example, if you have 1 GB of available virtual memory, you can only index documents that are smaller than 1 GB.

Query restrictions

You cannot include basic text search queries in distributed queries or parallel database queries.