Hello, On Sonntag, 10. November 2002 12:39, Sven K�hler wrote: > > > How do I make a SAPDB case-insensitive? > > > > What do you mean? > > > > If you mean: "How do I match a value case-insensitively?" > > Then there are two answers: > > > > 1) Don't, store the uppercase or lowercase version of the value and > > match that, this is good if you want to do large searches that need > > to be indexed. > > Any ideas, why this should not be implemented? > Probably, because SQL by itself is by definition case-sensitive (even table names are, as long as you quote them). So changing the behaviour would break not only the standards but probably several well-running programs too.
You could always generate a column width an all-uppercase version of the word you want to search for (perhaps silently in the background by using a trigger) and then look up this column, or you could always check against a column's upper case equivalent like --> where upper(name) like 'FRED' instead of --> where name like 'FRED' or similiar. Switching from an m$ access database (yes, m$ access is case-insensitive) to sapdb and having to rewrite several statements that way. I did not notice any decay in performance. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
