Subject Re: [firebird-support] Case insensitive queries in Firebird 3 ?
Author Alexandre Benson Smith
Carsten Schäfer wrote:

>will there be case insensitive queries that can use an index in Firebird 3 ?
>I often see questions about this issue in this newsgroup and now i want
>to know if this problem will be adressed in the next future ?
>I think it would be a very useful feature.

Yes, It's already done in FB 2.0 that is in beta. Give it a try !

The work that was start of the new International Interface are in use
for some years here in Brazil, I use it in production for years and it
is rock solid. It permits indexed case/accent insensitive search/sort,
works with LIKE, CONTAINING and START WITH operators.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil