Problem with select

[Ruslan Zasukhin]

On 28/10/07 10:08 PM, "Joseph Morgan" <joseph at checkos.com> wrote:

>> 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.

Yes and please attach this db with TEXT field.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]