Hello,

A BLOB is a binary large object that can hold a
variable amount of data. The four BLOB types TINYBLOB,
BLOB, MEDIUMBLOB, and LONGBLOB differ only in the
maximum length of the values they can hold.

The four TEXT types TINYTEXT, TEXT, MEDIUMTEXT, and
LONGTEXT correspond to the four BLOB types and have
the same maximum lengths and storage requirements. The
only difference between BLOB and TEXT types is that
sorting and comparison is performed in case-sensitive
fashion for BLOB values and case-insensitive fashion
for TEXT values. In other words, a TEXT is a
case-insensitive BLOB. No case conversion takes place
during storage or retrieval. 

If you assign a value to a BLOB or TEXT column that
exceeds the column type's maximum length, the value is
truncated to fit. 

Please read details at the address below:

http://www.mysql.com/doc/en/BLOB.html

Regarding hiding password from people accessing the
database take a look at these:

http://www.mysql.com/doc/en/Encryption_functions.html

http://www.mysql.com/documentation/connector-j/index.html

http://au.php.net/manual/en/function.md5.php

Unoffical sites:

http://www.allhype.co.uk/freestuff/scripts/php/md5/

http://www.teencoderz.com/article.php?story=20030808200312747

http://halfos.street-tv.net/lib/php/function.md5.php.htm

I hope this helps.  Any questions please reply to the
board. :)  ([EMAIL PROTECTED])

Jerry



From: "Ng Hwee Hwee" <[EMAIL PROTECTED]> 
To: "PHP DB" <[EMAIL PROTECTED]> 
Date: Mon, 15 Mar 2004 09:18:50 +0800 
Subject: Re: [PHP-DB] BLOB 

hi all..

thank you so much for your help!

i tried out the all the different syntax and the
following works 
perfectly

SELECT * FROM `MEMBER` WHERE `PASSWD` = ""

thanx, amanda!

btw, i was trying to store the encryted password in
the database but i 
do
not want anyone who has the right to see the database
(even myself!) to 
be
able to know the password, so that there is maximum
'security'. That's 
why i
used the blob field for my password.. hmmm... is this
the right way of 
doing
things?

hwee





Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

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

Reply via email to