Depends on database ... in Oracle yes data is stored in mixed case so you 
can use functions like UPPER & LOWER to force case.


Roy A. Jones 
US Pharma Database Administration 
GlaxoSmithKline Inc. US Pharma IT, Shared Services 
Email: [EMAIL PROTECTED] 
http://usphdba.gsk.com/ - USPHARMA Database Site 



"Ron Piggott" <[EMAIL PROTECTED]> 
06-Oct-2005 03:02
Please respond to "Ron Piggott" <[EMAIL PROTECTED]>

 
To
"PHP DB" <php-db@lists.php.net>
cc

Subject
[PHP-DB] is SELECT case sensitive






Is SELECT typically case sensitive?  Is there a way to make it case
sensitive?  (In the example below can $searching_criteria become case
sensitive?)

SELECT * FROM table_name WHERE column  LIKE '$searching_criteria';

Ron

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to