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--
form method=post action=document.php enctype=multipart/form-data
input type=hidden name=MAX_FILE_SIZE
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 up
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 +0900
I would
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:
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
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.
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: php-db@lists.php.net
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:
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
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);
11 matches
Mail list logo