better to use the sql UPPER/LOWER and keep your variable values the same
Except that they should be escaping the variable to make it db-safe so
that will change it ... so if you're going to do that, might as well do
this:
$safe_stringinput = _escape_string(strtoupper($stringinput);
One
Check to see if you have the Binary option on the field. That would
make searches case sensitive. If it is a binary field, you need to
drop the binary option.
On Aug 24, 2005, at 4:53 PM, Chris Payne wrote:
Hi there everyone,
I have a little problem, I have a search where people can sea
better to use the sql UPPER/LOWER and keep your variable values the same
Bastien
From: <[EMAIL PROTECTED]>
To:
CC: <[EMAIL PROTECTED]>
Subject: Re: [PHP-DB] Case sensitive
Date: Wed, 24 Aug 2005 14:29:56 -0400
One trick is to force the case in your comparison:
$ucstringinput = strtoupper($s
One trick is to force the case in your comparison:
$ucstringinput = strtoupper($stringinput);
$qry = "select * from sometable where upper(address) like '%$ucstringinput%'"
Didn't think LIKE was case sensitive, but regardless... forcing upper or
lowercase in your comparison doesn't affect output
Perhaps its a collatioon issue? Are you using the same characterset for
both?
Bastien
From: Micah Stevens <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Case sensitive
Date: Wed, 24 Aug 2005 11:26:38 -0700
Not sure here, as according to my experience, and the MySQL docs,
In fact, by issuing the following query:
SELECT "TEST" LIKE "test";
you can prove this to yourself, if it's case insensitive, it will return true
(1), otherwise false (0).
-Micah
On Wednesday 24 August 2005 1:53 pm, Chris Payne wrote:
> Hi there everyone,
>
>
>
> I have a little problem, I
Not sure here, as according to my experience, and the MySQL docs, SQL pattern
matching (as you would use with the 'LIKE' syntax) is case-insensitive. From
the docs:
"In MySQL, SQL patterns are case-insensitive by default. Some examples are
shown here. "
http://dev.mysql.com/doc/mysql/en/patte
Hi there everyone,
I have a little problem, I have a search where people can search the address
of a property BUT the search is case sensitive, I don’t WANT it to be. I’m
using MySQL and PHP and I generally use something like WHERE address LIKE
‘%$stringinput%’ which works with the numbers ONL
what's the db? assuming mysql
(http://dev.mysql.com/doc/mysql/en/storage-requirements.html)
BLOB, TEXT L+2 bytes, where L < 2^16 (that's 2 to the power of 16)
Bastien
From: Yui Hiroaki <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Bastien Koert <[EMAIL PROTECTED]>
CC: php-db@list
> Check the docs for your db
Yes, your right.But I can not find the documentation of max of blog?
yui
> bastien
>
>
>> From: Yui Hiroaki <[EMAIL PROTECTED]>
>> Reply-To: [EMAIL PROTECTED]
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] max upload blob size
>> Date: Wed, 24 Aug 2005 19:31:02
Check the docs for your db
bastien
From: Yui Hiroaki <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] max upload blob size
Date: Wed, 24 Aug 2005 19:31:02 +0900
I would like to know how much maximum size's blob(binary data) from web
site? I have set u
I would like to know how much maximum size's blob(binary data) from web
site? I have set up 512000, I would like to extend value.
Code--
-
--
PHP Database Mailing List (http://ww
12 matches
Mail list logo
