Hi,
I've made it work with DUMPFILE but its a BIG workaround for my php
aplication:
To insert I have to read the file received from the browser $_FILES[tmp_name]
placed it in a directory for MySQL to read it, and them insert it into MySQL
table with LOAD_FILE
To extract I have to use DUMPFILE a
Hi,
I remembered something when playing wiht BLOB. It looks that the select
statement does not
work well with BLOB. It always add or modify the BLOB a little bit.
Later I found out that
the client programming interfaces, perl,C++ etc tend to do well on BLOB
and files.
Kemin
Gleb Paharenk
Hello.
Use DUMPFILE instead of OUTFILE. See:
http://dev.mysql.com/doc/mysql/en/select.html
jose nuno neto <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to use MySQL Blob columns to store files (docs,gifs,pdf.) but
> I'm getting corrupted files from the DB.
>
> the applicat
Hi,
I'm trying to use MySQL Blob columns to store files (docs,gifs,pdf.) but
I'm getting corrupted files from the DB.
the applications runs php, loading file content with addslashes but in order
to spot the error i've tried it with mysql only like this:
column file is a MEDIUMBLOB
INSERT IN