Yes you are right, I have tried the queries on Oracle and MySQL, it works right on MySQL (case insensitive) but not on Oracle. Thank you for the correction. ----- Original Message ----- From: roy.a.jones@xxxxxxx To: mocak@xxxxxxxxxx ; php-db@xxxxxxxxxxxxx Sent: Wednesday, November 19, 2003 2:36 PM Subject: Re: Query Case In-sensitive As an Oracle DBA (9+ years, versions 7.x - 9.x) I just wanted to make a correction. The LIKE command uses wild card characters ( _ and % ) for substitutions. Oracle IS a case-sensitive RDBMS and the LIKE command will NOT do case-insensitive queries. Roy A. Jones ------------------------------------------------------------------------------ US Pharma Database Administration GlaxoSmithKline Inc. US Pharma IT, Shared Services ------------------------------------------------------------------------------ External: (919) 483-0266 Internal: 703-0266 Fax: (919) 315-6842 Office: RC2 - 2005 Email: roy.a.jones@xxxxxxx ------------------------------------------------------------------------------ http://usphdba.gsk.com/ - USPHARMA Database Site "mustafa ocak" <mocak@xxxxxxxxxx> 19-Nov-2003 07:11 To php-db@xxxxxxxxxxxxx cc Subject Re: Query Case In-sensitive Use "LIKE" clause instead of "=" SELECT item_number FROM item WHERE item_code LIKE 'M1234' ; This will perform case-insensitive matching on all databases I used before (Including Oracle, MySQL, SQL-Server) ----- Original Message ----- From: "ramki" <ramki@xxxxxxxxxxxxxx> To: <lgs@xxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx> Sent: Tuesday, November 18, 2003 5:46 AM Subject: Re: Query Case In-sensitive > Generally in DBs, data is case sensitive. > > Simply you can do an uppercase or lowercase conversion in both sides. > > Ex : Select item number from item where upper(item_code) = upper("m1234"); > > -ramki > ----- Original Message ----- > From: "Larry Sandwick" <lgs@xxxxxxxxxxx> > To: <php-db@xxxxxxxxxxxxx> > Sent: Tuesday, November 18, 2003 1:23 AM > Subject: Query Case In-sensitive > > > > Is there a way to run a query so that it ignores the case, and the query > > is not case sensitive? > > > > The data being stored is "m1234" > > > > Query > > > > Select item number from item where item_code = "M1234" ; > > > > The query above should return the data above. > > > > TIA > > > > > > > > Larry Sandwick > > > > Sarreid, Ltd. > > > > Network/System Administrator > > > > phone: (252) 291-1414 x223 > > > > fax : (252) 237-1592 > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
