Previous Topic

Next Topic

Correct String Comparisons Within Case Insensitive Databases

A query of the system tables of a database that was created case insensitive (which is not the default), having a condition on a field not indexed, failed to retrieve the proper rows. Internal logic uses c-tree expressions that can perform comparison on strings using the "regular" comparison operators (=, >, < ...). However, these operators on strings are case sensitive. In the case of a case insensitive database this same logic cannot be used. New logic has been added such that case insensitive databases are identified as such and when comparing text fields within these databases, a proper string comparison is performed.