Extracting Files from LONG VARCHAR column

[fliewatueuet]

I have to extract files from a SQLBase 7 Database.

The structure is like:

id int
ext char(3)
dok long varchar

The table looks like:

1 DOC <some funny chars>
2 XLS "
.......

Now I want to recreate the files, stored in the LONG VARCHAR COLUMN with filenames containing number and extension of the other columns, therefore

1.DOC should contain the Word document stored in the LONG VARCHAR column for this document and so on.

Have tried many things till now, but couldn't recreate it.

Unloading the database shows, that the content of the column is "encrypted" it some way, I think this results from converting binary data to varchar.

Any help or hint would be greatly appreciated!

Many thanks in advance!

 

[GuptaSteve]

Best advice is to go to the proper Gupta Sqlbase forum:

http://support.unify.com/supportforum/viewforum.php?f=27&sid=b8de77a07771ddbf55294ad340020b9d

and get some help from Mike Vandine and the Gupta boys - they're the best.