Subject | RE: [firebird-support] Re: General conventions for Upper/Lower case searching |
---|---|
Author | Alan McDonald |
Post date | 2004-11-13T22:45:56Z |
>when you setup the database you can design it's metadata to include
> 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.
>
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