Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Blob binary format

    hi ppl
    I have here a weird problem, I received a database in Paradox format with 3 files for each table, db/mb/px, I could manage to convert them all into access by access import but there's some BLOB fields which I couldn't do anything about them. so I downloaded a tool called DATABASE WORKSHOP and I could get more detail of these blob and I could convert one of the table into dBase format and convert it into access but the data inside is screwed after at , how do I manage to recover it and where exactly i can read a good article about these binary data, Couldn't find anything useful in borland website

    here's the table structure

    CREATE TABLE data1(
    WordID AUTOINC,
    Word CHAR(30),
    Mean BLOB(,2)(1),
    Verb BLOB(,1)(1),
    VerbMean BLOB(,1)(1),
    Synonym BLOB(,1)(1),
    Antonym BLOB(,1)(1),
    Inflections BLOB(,1)(1),
    Derivatives BLOB(,1)(1),
    Examples BLOB(,1)(1),
    Pic BOOLEAN,
    Avi BOOLEAN

    there's also another table contain audio files, after I export it to Dbase and I import it into access the audio which suppose to be OLE format is become Memo and it is also screwed

    here's the table struction for the second table

    Word CHAR(100),
    Pronounce BLOB(,2)(100)


    any help is highly appreciated

    by the way I'm not so sure which version of paradox is it , any way to determine it for sure?

  2. #2
    Join Date
    Aug 2003
    Location
    Bologna - Italy
    Posts
    209
    I think nearly all of these fiels are in fact Memo fields.

    Have you tried importing them as such?
    The only failure is not trying to do it.

Posting Permissions

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