Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: vlado buzalka
  Where is vlado buzalka?
 praha
 Czech Republic
 vlado buzalka
 Tags
Subject: RE: how to store file in mysql database from
Thread ID: 373479 Message ID: 373524 # Views: 39 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 9:26:54 PM         
   


> >
> > Why shouldn't it be advisable? In today's world it is a fair request I think - data is not simply short and primitive values anymore (for example carfax, facebook, youtube, github, groupon ... all store data, don't they).
> >
> > I don't use MySQL but I expect to be straight forward insertion to a BLOB field. If it were SQL server:
> >
> >
lcValue = createbinary(myFile) && assuming it is a binary file
> > SQLExec(m.handle, 'insert into myTable (myBlobField) values (?m.lcValue)')

> >
> > With a cursoradapter it would be a simple tableupdate call.
> >
> >

> > Cetin Basoz
> >
> > .Net has got better.Think about moving - check my blog:
> > My Blog
> >

> > MongoDb Certified Developer
> > MongoDb Certified DBA
> >

> > Support Wikipedia
>
>
> THANKS A LOT, IT WORKS, but Cetin, how to read it back?

Check this for a sample:

https://www.foxite.com/archives/0000239346.htm



Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog


MongoDb Certified Developer
MongoDb Certified DBA


Support Wikipedia

ENTIRE THREAD

how to store file in mysql database from Posted by vlado buzalka @ 3/22/2013 12:49:12 PM
RE: how to store file in mysql database from Posted by Cetin Basoz @ 3/22/2013 1:13:17 PM
RE: how to store file in mysql database from Posted by vlado buzalka @ 3/22/2013 6:56:11 PM
RE: how to store file in mysql database from Posted by Cetin Basoz @ 3/22/2013 9:26:54 PM