Receiving a search error in the Thai language when database setup is incorrect

If the database and the text index is not created in a specific way, the search for Thai phrases in IBM® Content Manager results in an error.

Symptoms

When you do a text search of Thai language content, you can perform one word searches or phrased searches. When you perform a phrased search, you get an error.

Resolving the problem

To support phrased searches in Thai content in IBM Content Manager, the database and the text index must be created in one of the following ways:
  • Create the Db2® database in the Thai codepage or in Unicode.
  • Create the text index in the Thai code page with the language specified as TH_TH or in the Thai code page CCSID 1208.

To search for one Thai word by using the advanced text search syntax: /MyItemTypeView[contains-text(ICMPARTS/@TIEREF, “ ‘Thai word’ ”)=1]

To search for Thai phrases by using the Db2 Thai-specific advanced text search syntax: /MyItemTypeView[contains-text-db2(ICMPARTS/@TIEREF, \“ IS ABOUT TH_TH ‘Thai phrase’ \”)=1]