Re: [PHP-DB] MySQL and BLOB

[Martin Adler]

maybe RTFM is not the answer!!!
i think this will help a little more
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Sto
rage_requirements

greet
Martin


- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 22, 2002 8:17 AM
Subject: Re: [PHP-DB] MySQL and BLOB


 On Thursday 22 August 2002 13:57, Andy wrote:

  Hi there,
 
  I am storing via PHP pictures into BLOB fields. Worked fine so far for
over
  200 images.
  Now an error has occured with a particular picture. No error msg. Just
does
  not work. The wired thing is that the thumbnail does. So I guess the
BLOB
  field is just to small for the image.
 
  How many kb can a blob field savin in MySQL

 Depends on what type of BLOB. Why don't you RFTM?

  and what do you suggest to do.

 Probably the usual, not to store files in MySQL where possible.

 --
 Jason Wong - Gremlins Associates - www.gremlins.com.hk
 Open Source Software Systems Integrators
 * Web Design  Hosting * Internet  Intranet Applications Development *


 /*
 Never buy from a rich salesman.
 -- Goldenstern
 */


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] want to compare text input with blob field

[Smita Manohar]

hii
im using php with mysql 3.23
in my script im accepting text input and want to compare it with  the field 
which is of the type blob.

trying with following query.

SELECT * from table where fieldname LIKE '% $textinupt %'

but it is giving case sensitive result bcos the field which im comparing 
with text input is blob.
what should i do to avoid case sensitive result??? is it required to convert 
input text also in boob format?? then how to do that??

thnx and regds,
smita.



_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] want to compare text input with blob field

[Stuart McDonald]

Funny,
I just had the same problem!

I converted the blob column to a text column and then the problem went away.

This page may be of use from the MySQL manual:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html

But I couldn't get their solution to work, so I changed the format of the
column to TEXT and it works fine.

Cheers

stuart

- Original Message -
From: Smita Manohar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 22, 2002 3:51 PM
Subject: [PHP-DB] want to compare text input with blob field


 hii
 im using php with mysql 3.23
 in my script im accepting text input and want to compare it with  the
field
 which is of the type blob.

 trying with following query.

 SELECT * from table where fieldname LIKE '% $textinupt %'

 but it is giving case sensitive result bcos the field which im comparing
 with text input is blob.
 what should i do to avoid case sensitive result??? is it required to
convert
 input text also in boob format?? then how to do that??

 thnx and regds,
 smita.



 _
 Send and receive Hotmail on your mobile device: http://mobile.msn.com


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form validation question - regex not working

[Martin Adler]

If you realy want to match vaild E-Mailadresses (rfc822 conformal) you have
to do things like this

--- short pattern start --
!--StartFragment--(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\
((?:[^\\\x80-\xff\n
\015()]|\\[^\x80-\xff])*\))*\))*(?:(?:[^(\040)@,;:.\\\[\]\000-\037\x80-\
xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|(?:[^\\\x80-\xff\n\015
]|\\[^\x80-\xff])*)(?:(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xf
f]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*\.(?:[\040\t]|\((?:[
^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\
xff])*\))*\))*(?:[^(\040)@,;:.\\\[\]\000-\037\x80-\xff]+(?![^(\040)@,;
:.\\\[\]\000-\037\x80-\xff])|(?:[^\\\x80-\xff\n\015]|\\[^\x80-\xff])*))
*(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\
n\015()]|\\[^\x80-\xff])*\))*\))*@(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\
\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\04
0)@,;:.\\\[\]\000-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-
\xff])|\[(?:[^\\\x80-\xff\n\015\[\]]|\\[^\x80-\xff])*\])(?:(?:[\040\t]|\((?
:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80
-\xff])*\))*\))*\.(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\(
(?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)@,;:.\\\[\]
\000-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|\[(?:[^\\
\x80-\xff\n\015\[\]]|\\[^\x80-\xff])*\]))*|(?:[^(\040)@,;:.\\\[\]\000-\0
37\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|(?:[^\\\x80-\xf
f\n\015]|\\[^\x80-\xff])*)(?:[^()@,;:.\\\[\]\x80-\xff\000-\010\012-\03
7]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\
\[^\x80-\xff])*\))*\)|(?:[^\\\x80-\xff\n\015]|\\[^\x80-\xff])*)*(?:[\04
0\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]
|\\[^\x80-\xff])*\))*\))*(?:@(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x
80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)@
,;:.\\\[\]\000-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff]
)|\[(?:[^\\\x80-\xff\n\015\[\]]|\\[^\x80-\xff])*\])(?:(?:[\040\t]|\((?:[^\\
\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff
])*\))*\))*\.(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^
\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)@,;:.\\\[\]\000-
\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|\[(?:[^\\\x80-
\xff\n\015\[\]]|\\[^\x80-\xff])*\]))*(?:(?:[\040\t]|\((?:[^\\\x80-\xff\n\01
5()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*,(?
:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\0
15()]|\\[^\x80-\xff])*\))*\))*@(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^
\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)
@,;:.\\\[\]\000-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xf
f])|\[(?:[^\\\x80-\xff\n\015\[\]]|\\[^\x80-\xff])*\])(?:(?:[\040\t]|\((?:[^
\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\x
ff])*\))*\))*\.(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:
[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)@,;:.\\\[\]\00
0-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|\[(?:[^\\\x8
0-\xff\n\015\[\]]|\\[^\x80-\xff])*\]))*)*:(?:[\040\t]|\((?:[^\\\x80-\xff\n\
015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*)
?(?:[^(\040)@,;:.\\\[\]\000-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000
-\037\x80-\xff])|(?:[^\\\x80-\xff\n\015]|\\[^\x80-\xff])*)(?:(?:[\040\t]
|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[
^\x80-\xff])*\))*\))*\.(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xf
f]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)@,;:.\
\\[\]\000-\037\x80-\xff]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|(?:
[^\\\x80-\xff\n\015]|\\[^\x80-\xff])*))*(?:[\040\t]|\((?:[^\\\x80-\xff\n\

015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*@
(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n
\015()]|\\[^\x80-\xff])*\))*\))*(?:[^(\040)@,;:.\\\[\]\000-\037\x80-\xff
]+(?![^(\040)@,;:.\\\[\]\000-\037\x80-\xff])|\[(?:[^\\\x80-\xff\n\015\[\
]]|\\[^\x80-\xff])*\])(?:(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\
xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*\.(?:[\040\t]|\((?
:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80
-\xff])*\))*\))*(?:[^(\040)@,;:.\\\[\]\000-\037\x80-\xff]+(?![^(\040)@
,;:.\\\[\]\000-\037\x80-\xff])|\[(?:[^\\\x80-\xff\n\015\[\]]|\\[^\x80-\xff
])*\]))*(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\((?:[^\\\x8
0-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*)(?:[\040\t]|\((?:[^\\\x80-\xff\n\
015()]|\\[^\x80-\xff]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff])*\))*\))*

--- short pattern end --
you find it on
http://www.cpan.org/authors/Tom_Christiansen/scripts/ckaddr.gz

this should be