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:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.