>Hi,
>
>My application is written in VFP8 and uses filetostr and strtofile to store and retrieve data of a image in an text field of a SQL Server table. It works fine for certain files, but some files (Mostly grayscale pictures) show corruption when retrieving them from the table. I think it has something todo with code page translation, but I don't know how to alter this.
>

We do store jpegs and multi-page tiff in dbs (sql server and sybase ASA depending on the customer choice) via ODBC. No pbs with sybase ASA but a few quirks with "sql server"...

We store the blob (aka the file content) in db engines "as is" with no trans-codification. A subsequent advantage - not minor - is the fact the blob (jpeg and one-page-tiff) will show up nicely with a product such as Crystal Reports.

I do know is this helps... but we make sure that the blob container is mapped to a NOCPTRANS MEMO (in order to avoid random translation errors).

It generally works fine. I have had a few quirks with "SQL server 2000" when handling big blobs but certainly not related with the blob format itself.

It looks like thhe issue is more on the odbc front.

François