Problem with select

[Joseph Morgan]

On Oct 28, 2007, at 12:47 PM, Ruslan Zasukhin wrote:

> For TEXT fields that search also must work.
>
> You did not answer on my advice to REINDEX db.
Sorry, reindex didn't make the select work.

> During CHANGE TYPE - Valentina could re-index field.
>     so this can be double effect.
>
> Just for interest you can try change that field to TEXT again and  
> see if it
> start to works.

I don't think TEXT field is allowing proper searches.
I changed back to TEXT and select returned 0 results.
I changed back again from TEXT to VarChar and select worked.

I can report to mantis if you like.

Joseph