I have been using varchar for pictures and many text inputs that are often 4+ lines long. Everything has gone very well until I used Gateway to export a table to Excel. When I looked in the Excel file, the varchar columns were simply statements that read "[Blob]". The pictures and data were not there. I realize varchars are kept in a separate file from the other data so I assumed Gateway does not retrieve this separate data during an export. So two questions:
1. Does varchar work with Gateway at all or can this only be done through Load/Unload? 2. More importantly, is there a basic rationale on when to use text, note, or varchar in various settings. Something like (I am making this up) text = editable/less than 250 characters, note = some editable/250-2000 characters, and varchar = not easily editable/over 2000 characters/pictures. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org
