CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Newb working with blobs

  1. #1
    Join Date
    Jul 2011

    Newb working with blobs

    I have a database in SQLite which contain tables with blob fields. I have no experience at all working with blobs, and it wasn't me who wrote the blobs to the database. The problem is that I have to access this blob data, but I don't know how.

    I've understood that you can store alot of different information in blobs, like audio, images and text. In my case, I'm 99% certain that it's text or CSV in some way. I've been googeling for a couple of hours and can't really find much documentation or useful stuff.

    My question is:
    When you access a blob, do you have to know the way it was written in order to read it? How do you read it if you know it's some kind of text? The best thing would be to find a way in a VBA enviroment to read the blobs (working with an excel frontend).

    Useful links are greatly appreciated


  2. #2
    John E is offline Elite Member Power Poster
    Join Date
    Apr 2001
    Manchester, England

    Re: Newb working with blobs

    I know nothing at all about blobs but I found this article which might hopefully help you:-
    "A problem well stated is a problem half solved. - Charles F. Kettering

  3. #3
    Join Date
    Nov 2000
    Voronezh, Russia

    Re: Newb working with blobs

    When you access a blob, do you have to know the way it was written in order to read it?
    When you access the blob, you just read its bytes from db to some buffer. When you work with the buffer content somehow later, of course you have to know a format those bytes were written with.
    Best regards,

  4. #4
    Join Date
    Jul 2011

    Re: Newb working with blobs

    Ok, thank you both... I think I'll have to dig deeper in this and try to understand it more thoroughly.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)