The photos are JPEGs, and the varbinary column is recognised by FME as a field of type IMAGE.
I connected a RasterReplacer to the attribute with JPEG format but get "not recognised as a supported file format"
Any ideas greatly appreciated.
Ian
Question
SQL Server varbinary
I'm trying to retrieve photos stored in a non-spatial SQL Server table in a varbinary(max) column, input37_bin:
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
sorry, "0x" is just being displayed by the database management tool. It may not be the reason for the trouble.
If you connect a Logger or an Inspector to the reader feature type directly, how is the attribute value shown?
Hi Takashi, thanks for the reply.
In answering your question, the answer presented itself: the 1st 2 rows of the table in question have <null> for the binary field (which shouldn't happen, but that's another story). The <null> is tripping up the RasterReplacer - if I filter <null> out, the rest of the binary fields are read in fine.