Re: Oracle case-insensitive
| From: | Jamie Alessio | Date: | Thu, 02 Nov 2000 17:44:16 +0000 |
| Subject: | Re: Oracle case-insensitive | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4151@lists.php.net to get a copy of this message | ||
> Hi, I run a query for Oracle 8i.
> How can I run case-insensitive query against it? Because it always
> case-sensitive.
>
Just uppercase or lowercase everything when you compare it. Use Oracle's built-in
functions for this. I can't think of the exact name of it now but I believe it is LOWER so
a query would look something like this:
select * from some_table where lower(some_table_field) = lower($some_php_variable)
Again, check that function name but that's the general idea.
- Jamie