Hi @manojse07 

I tested this out and although I can’t quite tell if the decoded result is what you were looking for I was able to decode the blob format.

I first read in the table from that zip file with an SQLite reader. 

Then I added a TextDecoder transformer. 

I set the ‘encoding type’ to Base64 and the ‘string to decode’ as the _TAGOBJ_SUBSTATIONGID field. 

You can try a different value for the ‘character encoding for binary data’ as each one will give a slightly different result. 

I hope this works! 

Crystal 

Thanks @cfitzpat for you answer. I did try the transformer you suggested and is still returning some garbage values. The actual value I am expecting is a GUID

Considering that the data type returned by sqlite reader for blob type is “binarybuffer” can we do something to achieve what is intended?

@manojse07 What software are you viewing the .db3 file in? 

I’ve checked the FME SQLite Reader parameters and it detects the data type as a Blob for your dataset so it should be reading in the values correctly.

I’ve cross-referenced reading the data in other database management programs (DBeaver) and a SQLite specific database reader (https://alpha.sqliteviewer.app/) and the results are consistent with what FME produces.

@danminneyatsaf All the software you mentioned show the hex representation of the blob object. My problem statement is that I have to decode it to the text. If you can check my question - the value is actually a GUID that is encoded as a blob in the db3. So, when I read using FME I have to decode as a GUID.