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, the text search feature for Db2 for z/OS® 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

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

All of the CCSIDs that are supported for conversion to UTF-8 by z/OS Unicode Conversion Services are supported by the text search feature for Db2 for z/OS. To display active conversions to UTF-8 on your system, use command D UNI,CONV,TOID=1208.