Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why would I use a Blob field
Message
 
 
To
09/06/2006 13:13:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01128182
Message ID:
01128292
Views:
23
This message has been marked as the solution to the initial question of the thread.
The Blob data type was introduced to improve VFP compabilty with MS SQL Server and other RDBMS. Using it makes workarounds described in How to work with Image field type on SQL Server (binary data)? FAQ #7995 unnecessary.

>
>Usually I used a Memo field to save image files in a table. Now there is a new data type, Blob, that I can use to save the image file, even with the same code as the memo:
>
APPEND MEMO MyBlobField FROM Test.JPG OVERWRITE
>Could somebody explain me what the advantages would be of using a blob field instead of a memo field?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform