Insert container contents into SQL Server Varbinary

[Martyn Brake]

Hello,

 

I am trying to get the contents of a container field (a jpeg) into a VarBinary column in SQL Server.

 

I tried using MMQuery, but i do not think the defintiion of the VarBinary column is recognised via the ODBC/ESS Filemaker connection.

 

Could you please confirm this, or even better, let me know what i am doing wrong!!

 

Many thanks,

Martyn

[mr_vodka]

Binary data is not able to be used via ESS.

 

http://help.filemaker.com/app/answers/detail/a_id/6425/~/datatypes-and-field-mapping-with-filemaker

 

http://www.filemaker.com/support/product/docs/12/fmp/fm12_odbc_jdbc_guide_en.pdf