Posted by Alan Little on 05/18/06 14:49

Carved in mystic runes upon the very living rock, the last words of
Henrik Hansen of comp.lang.php make plain:

> "lawrence k" <lkrubner@geocities.com> writes:
>
>> Is it right to say that I can just open any file with file(), get it
>> as a string, and then store in a MySql database, in, say, a
>> MediumText field? I realize that MySql supports binary fields, but my
>> current MySql schema does not have any binary fields, and I'm
>> wondering if I can store the file without changing my current schema.
>
> AFAIK you need to use blob fields as your data is binary (or is it,
> what kind of files do you want to open?), if you store
> it in a normal text field it can be corrupted. But else you are right,
> you just take the ourput from the field and put in a file or output to
> the browser with a header infront.

You could base64_encode() it first.

--
Alan Little
Phorm PHP Form Processor
http://www.phorm.com/

[Back to original message]