Insert image files to mysql 4

CyberFox · #1 (**permalink**) 11-29-03, 19:33

Hi @all!

I want to store picture files in a mysql 4 database.

I've heard it has to be saved as a BLOB. But how do I insert a file, with a sql script or a with a vb programm? Do I have to read out the file in binary mode and save the string in the database as a blob?

I would be happy if anybody could help me!!

Thanx & Greez to all!

ika · #2 (**permalink**) 11-30-03, 10:53

Quote:

Originally posted by CyberFox
Hi @all!

I want to store picture files in a mysql 4 database.

I've heard it has to be saved as a BLOB. But how do I insert a file, with a sql script or a with a vb programm? Do I have to read out the file in binary mode and save the string in the database as a blob?

I would be happy if anybody could help me!!

Thanx & Greez to all!

http://www.dbforums.com/archives/t285836.html
http://www.vbmysql.com/forums/index....hread&frm_id=1
http://dev.nexen.net/docs/mysql/anno...bc-clients.php