When you store data in a column having a binary data type, for example BLOB, FOR BIT DATA, or a datalink value, DB2 does not convert the data. This means that the documents retain their original code pages (CCSIDs), which can cause problems when creating a text index as you might have two different code pages. Therefore, you need to determine whether you are using the code page of the database, or the code page specified in the CREATE INDEX command.
To avoid this problem, specify the code page when creating the text index:
db2text CREATE INDEX db2ext.comment FOR TEXT ON db2ext.texttab (comment) CCSID 1252
If the code page is not specified, check which CCSID has been used to create the index, by calling:
db2 SELECT ccsid FROM db2ext.textindexes WHERE INDSCHEMA = 'COMMENT' and INDNAME = 'DB2EXT'
Note that there is no support for having documents with different code pages in one text index. For information on how DB2 converts document code page settings, go to the DB2 Universal Database Administration Guide. See Related information.
Note that there is no such problem with creating indexes on character data types.