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
SQL Server varbinary
I'm trying to retrieve photos stored in a non-spatial SQL Server table in a varbinary(max) column, input37_bin:
Userlevel 2
+17
- Contributor
- 7538 replies
-
24 April 2015
Hi Ian,
How about deleting "0x" in the head of the blob?
Takashi
Userlevel 2
+17
- Contributor
- 7538 replies
-
24 April 2015
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.