Hi!
The best way to store binary data on SQL Server is to use image field on SQL Server. You're asking right question about general field - it is quite messy to handle it. There are workaround to use Memo field in VFP to store binary data and than map it to image field on SQL server. See following
FAQ#7995713 in Frequently Asked Questions section -> Client/server -> "How to work with Image field type on SQL Server?"
>We are hoping to scan all incoming post using a VFP Frontend.
>
>We want the results of these scans to be stored in a SQL Server backend and accessed over our WAN (Kilostream so pretty slow)
>
>1. Does SQL Server support the General Fields neccesary to store our scans.
>
>2. Is our WAN too slow.
>
>3. Is this a good idea or is their a better way we dont know about.
>
>Many Thanks
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.