Subject Re: [IBO] TIB_IncSearch and case
Author Geoff Worboys
> 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.

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 uses CompareStr and CompareText functions.

hth

--
Geoff Worboys
Telesis Computing