Subject Re: [IBO] TIB_IncSearch and case
Author Russell Belding
Thank you Geoff.

"Geoff Worboys" <geoff@...> wrote in message
> > 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.