Supported data types

The data in the text columns that you want to index and search can be either binary data or character data.

The following data types are binary data:
  • BINARY
  • VARBINARY
  • BLOB
In addition, OMNIFIND handles the following data types similarly to binary data:
  • CHAR FOR BIT DATA
  • VARCHAR FOR BIT DATA
The following data types are character data:
  • CHAR FOR SBCS DATA or FOR MIXED DATA
  • VARCHAR FOR SBCS DATA or FOR MIXED DATA
  • CLOB
  • DBCLOB
  • GRAPHIC
  • VARGRAPHIC
  • XML

If the data is binary data, you can specify the coded character set identifier (CCSID) used to build the text search index. For character data, the DB2® database knows the encoding; therefore, if you explicitly specify a CCSID, that specification is ignored.