[V4MD2] case insensitive sqlSelect

[Ruslan Zasukhin]

On 7/1/05 8:59 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

> REINDEX DATABASE doesn't help
> 
> 
> On 7/1/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
>> On 7/1/05 8:18 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:
>> 
>>> On 7/1/05 7:19 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:
>>> 
>>>> how is the REINDEX DATABASE command used inside director?
>>> 
>>>     SqlExecute( "REINDEX DATABASE" )
>> 
>> We have just only test V4MD  Examples/SQL/IndexByWords,
>> And it do case-insensitive searches fine.

Again

1) please try our example,

    we do search on VarChar field of StartWith  "WO"
    and this finds record with "world"

    confirm that example work for you

2) try at first make db, set collation, then add records.




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