Problems with indexing large data using verity

[rviner]

Hi,

I am currently running coldfusion 8 with verity running on a K2 server. I am using a query to index several different columns with my table using cfindex. One of the columns is a large varchar type.

It seems that when the data is being indexed only the first 30KB is being stored, resulting in no results being brought back if I search for anything after that. I tried moving several different phrases and words further up in the data,  within the 30KB and the results then appear.

Does anyone know if there is a limit to the amount of data being indexed and if there is a way to change this in the configuration?

Many thanks,

Richard

[rviner]

I have been running a few more tests and using the browse command in the command prompt to see whats actually in the collection.

i.e. Coldfusion8\verity\collections\<collectionname>\parts  browse 0000001.ddd

I found out that the body being indexed (CF_BODY) never exceeds the size of 32000.

Can anyone tell me if there is a fixed index size limit for verity or if it may be a coldfusion memory setting or database setting?

I'm using SQL server 2005 to run my query to update the collection.

Many Thanks,

Richard