Thank you Geoff.


"Geoff Worboys" <geoff@...> wrote in message
news:10153751437.20020508224211@......

> > Can someone verify TIB_IncSearch is case sensitive?
>
> My best guess from what you have said is...
>
> IB/FB with character set NONE perform sorting by ASCII, which put all
> uppercase and then all lowercase. Windows performs ANSI sorts which
> puts lower case preceeding the corresponding upper case.

That is the cause.

>
> This discrepancy often causes difficulties.
>
> You either need to use a character set in your database that will
> agree with Windows - or attach code to the CustomCompareStr and
> CustomCompareText events of TIB_Connection. For example to perform
> ASCII comparisons use CompareStr and CompareText functions.
>

That is a solution.

Russell