problem with binary data

[Anon]

Hi...

I'm using php-4.0.6/4.1.2 and mysql 3.23.47.

I try to store files into database (as binary) using file uploads from browser. Then i wrote a script to download it. For image (.gif etc), pdf, word (.doc)
and few others seems ok.... But i'm having problem with zip (.zip) and lotus word pro (.lwp). I assume that the files are corrupted coz it will display error
when i try to open it ...but why other binary data (.doc, .pdf, image files) have no problem with it.

Can anyone help me on this.... is it have anything to do with mysql...

[Anon]

Azam,

not sure wether this solves your problem, but I might be able to point in the right direction: you should use binary-safe string functions only to process your uploads and downloads. Possibly some files a corrupt because they contain 0 characters which some php function consider "end of string".

I have found out that reading a file with read, then outputting it breaks some files, whereas using fpassthru works fine.

Hope this helps you

Steve