Information générale
Catégorie:
COM/DCOM et OLE Automation
>>Come again? I'm not sure what a binary memo is and I'm not sure what part of the process you are referring to? Are you saying that I can convert the binary to memo text, save it to the oracle server and then when I need to download it, convert it back into binary, save as a file and then load it up as an OLE object? I hope so, it sounds like a much better solution.
Sorry, I overlooked the "Oracle" part.
In Visual FoxPro native tables, there are memo, and binary memo, fields. Memos accept variable character length, and are store in a separate file - instead of the DBF, a separate FPT file is used.
A normal memo or character field can be subject to automatic changes, due to codepages. These fields are appropriate for text. A binary memo or character field will not be changed, and is therefore more appropriate for storing binary data.
Although this explanation applies to VFP, perhaps you might do something similar in Oracle: store in a memo field instead of a general field. Or whatever the equivalent in Oracle is called.?>>
Hopefully, sometime in the future I'll have some time to play around with this, but we've decided to shelve it for the moment.
Oracle doesn't have a seperate memo. We just use very long strings (varchar2(4000) to be accurate).
Thanks again..Pablo
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement