I could imagine a case-insensitive index by using a special compare-function for strings:> 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.
for example "a" < "A" < "b" < "B" < "c" < "C" etc.
That allows to search for a string "aBc" case-insensitive by outputting all values in the interval ["abc";"ABC"].
The index still allowes search case-sensitive ... because "a"!="A" etc.
Any ideas, why this should not be implemented?
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
