Insert BLOB into MS Access using ODBC

admin

Administrator
Staff member
Help!!!

How to write binary large objects into MS Access database?
I'm have a database table with next structure:

id counter
filename char(255)
filecontent Ole object

By viewing a PHP 4.0 php_odbc.cpp source file, I'm create a simple query:

INSERT INTO fil_table (filename, filecontent) VALUES ("filename", ?)

next, i'm execute an odbc_prepare function
next, i'm create an array variable and set her first value to <'filename'>, and next i'm execute an odbc_execute function

But when i get a file - his size << size of source file, and content written in unicode codepage.

Pleace help me to find a way.
Thanks.
 
Back
Top