[Phpgroupware-tracker] [ 100439 ] Pattern Matching with LIKE with pgsql

[nobody]

Support Request #100439, was updated on 2002-Feb-15 09:02
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100439&group_id=509

Category: Bug Report
Status: Open
Priority: 5
Summary: Pattern Matching with LIKE with pgsql

By: sigurdne
Date: 2002-Feb-15 09:02

Message:
Logged In: YES 
user_id=5071
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)

The keyword LIKE with pgsql is case sensitive. The 
keyword ILIKE can be used instead of LIKE to make the 
match case insensitive where it is appropriate.

if ($phpgw_info['server']['db_type']=='pgsql')
        {
                $LIKE = " ILIKE ";
        }



Sigurd

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100439&group_id=509