>I am trying to store small image files (png files) in the database. What data type should I use to do this? Is there any disadvantage in storing the image file in the database?
>
>My initial guess is to use the memo binary field type. If I do, then what commands would I use to to upload and download the file into the database.
>
>Thanx
Gnana,
Memo is fine for this purpose. You can use APPEND MEMO ... FROM ... to read the PNG fiel into teh memo and COPY MEMO ... TO ... to copy teh file out of the memo. A general field is ok for storing the files but there is no way to get it back out again.