Creating a Text Configuration Using Interactive SQL

Create a text configuration to specify how TEXT indexes dependent on the text configuration process handle terms within the data.

  1. Connect to the database as a user with DBA or RESOURCE authority.
  2. Execute a CREATE TEXT CONFIGURATION statement.

To create a text configuration object called myTxtConfig using the default_char text configuration object as a template:

CREATE TEXT CONFIGURATION myTxtConfig FROM default_char;
Parent topic: Text Configuration Objects