Re: BLOB

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. :) (php-db@lists.php.net) Jerry From: "Ng Hwee Hwee" <hhwee@towa.com.sg> To: "PHP DB" <php-db@lists.php.net> 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