>Why does it become easier in VFP9? I can upgrade the project if I need to.

Hi Margaret,

The text column may work for you if you can be sure that no code page translation will occur between VFP and SQL Server. It most likely will be the case if you're only using Windows-1252 (default) code page and SQL Server is configured accordingly.

The image data type by default is mapped in VFP to general field in views and SPT. In views you can change mapping to a Memo but in SPT it's not possible. VFP9 has new blob data type and image can be maped to it in both cases.