Considering usefulness in query and performance, it is ideal to allow
server to exclusively set "CASE inSITIVITY" as in MS SERVER.

When doing search text, the performance is terrible unless creating
duplicated upper column with index.

jw

--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:

> We have, at various times, considered two alternatives.
> One is a set of special operators that are explicitly
> case insensitive. That's really non-standard, but it's
> very clean, architecturally.

This is ideal as MS SQL Server has such settings. Its default is
caseInSensitive.