Save binary file from BLOB field with TmySQL

[vilian]

I have a very large file. I need to split this file into several pieces and save in MySQL database.

I'm using fopen / fread to read these parts of the file, but can not save them in a blob field in my database.

As I read the parts of the file to be able to write into the blob?

[Lautaro]

Hello Vilian,

You can convert the parts in a mime64 format and save this in a varchar field like this

Code: Select all  Expand view

local nhfile
local ctemp

...
...

 do while fread(nhfile,@ctemp,5000) > 0
     xxobj:field := cmimeenc(ctemp)
     ....
     ....
enddo
 

where xxobj is the form with you open the mysql database.

For read only replace cmimeenc with cmimedec.

This working in harbour.

Best Regards,

Lautaro Moreira
Osorno
Chile

PD : Sorry for my bad english

[vilian]

Thanks Lautaro.