Subject RE: [firebird-support] Re: General conventions for Upper/Lower case searching
Author Alan McDonald
>
> Are you saying that in Firebird, unlike (say) Sybase and Microsoft
> SQL Servers, there is not an option when you set up a database for
> everything to be case-insensitive, so that "equals" matching is
> always case insensitive? That could be a problem for some users, such
> as myself.
>

when you setup the database you can design it's metadata to include
uppercase versions of the relevant columns you wish to search. You then
search these columns when case insensitive searches are required.
another alternative is to use
WHERE UPPER(COLUMNNAME) LIKE UPPER(:PARAM)
or some other similar use of UPPER clauses
Alan