Back

Filtering and Searching
upperCase
Searches will change in the where clause COL='value' to upper(COL)='value' Default: `false` Only fields of type C or X (CHAR, VARCHAR2, CLOB) will be uppercased. In the most general case, you need to set $lens->upperCase = true; $lens->toUpper = true; because when you have COL = 'somevalue', you need to uppercase both sides like this: UPPER(COL) = UPPER('somevalue') Now upperCase does this for the left hand side(COL) and toUpper does it for the right hand side ('somevalue'). Oracle note: For Oracle (oci8) you will need to enable function indexes for best performance. This ensures that the SQL optimizer binds the the upper(COL) index correctly. Syntax `$lens->upperCase = true;` Basic:Yes Advanced/Enterprise:Yes DynamicEdit:No [Version 1.3]