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
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
> 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
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
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
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
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
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,
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
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
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
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
12 matches
Mail list logo
