Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difference between blob and memo?

Status
Not open for further replies.
Ivanq

Ivanq

Programmer
Aug 30, 2005
8
US
I've been storing image files to a memo field in a table. Now, in VFP 9, we have the blob field type so my question is - is there an advantage to now storing image files in a blob field and, if so, what are the differences?

TIA,
Cliff - - -
 
Sort by date Sort by votes
Cliff,

I imagine it was put in for SQL Server compatibility (SQL image data type). There are probably other reasons that I don't know off the top of my head.

Andy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TinyNinja
  • Locked
  • Question
Blob Image on Report not picking the correct image
Replies
4
Views
285
TinyNinja
TinyNinja
mjcmkrsr
  • Locked
  • Question
Difference between dates
Replies
0
Views
84
mjcmkrsr
mjcmkrsr
Rajesh Karunakaran
  • Locked
  • Question
Table corrupted, after repair accessing Memo field says "Cannot open memo field" 1
Replies
18
Views
311
Gerrit Broekhuis
Gerrit Broekhuis
german12
  • Locked
  • Question
Searching in a big memo-field for a special info. 1
2
Replies
24
Views
304
Chris Miller
Chris Miller
AlastairP
  • Locked
  • Question
CHAR vs VARCHAR - no real difference size on disk 1
Replies
4
Views
188
AlastairP
AlastairP

Part and Inventory Search

Sponsor

Back
Top