Convert all strings in text boxes to uppercase (when saving and searching)
Default:
Useful for databases that require fields to be in uppercase for indexing purposes such as Oracle or PostgreSQL. Text entered in search screens is also uppercased.
Fields that are longer than 100 characters long are not converted to uppercase. You can change this setting in phplens/adodb/adodb-recordset.inc.php, class ADORecordSet->blobSize property.
Also see upperCase. 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'). Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.0]
|