This won't work if they're binary files.  Also, for most binaries, it's
better to use LONGBLOB... much more flexibility.  But there's a bunch of
stuff to tweak to get it to work.

http://www.phpbuilder.com/columns/florian19991014.php3 has details.

Ben

-----Original Message-----
From: Adam [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 10, 2001 3:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: Store uploaded files in MySQL-BLOB

I would suggest setting the database column to LONGTEXT instead of BLOB
since it can accomidate far more characters per entry.

As for the entry to the database through php, I'm not entirely sure what
method you're using to add these. Are they uploading their file and then
it
reads it as it exists on the server? Is it supposed to read a file they
specify with a browse but never actually upload it anywhere? It might be
better to just include a text field for them to cut+paste to in a form
if
it's nothing but text.

-Adam



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to