Re: is SELECT case sensitive
| From: | roy dot a dot jones at gsk dot com | Date: | Thu, 06 Oct 2005 13:08:13 +0000 |
| Subject: | Re: is SELECT case sensitive | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40474@lists.php.net to get a copy of this message | ||
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: roy.a.jones@gsk.com
http://usphdba.gsk.com/ - USPHARMA Database Site
"Ron Piggott" <ron.php@actsministries.org>
06-Oct-2005 03:02
Please respond to "Ron Piggott" <ron.php@actsministries.org>
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