Hi! A beginner here! I'm using tap-mysql and I'm trying to get some BLOB fields, but apparently is not possible. Is there some way or workaround to do this? Thanks!

A couple things I've done: • Convert the field to JSON if it actually contains JSON • Create a view that casts the field to TEXT or returns only the first n characters and then replicate the view ◦ That only works in FULL_TABLE or INCREMENTAL modes though 😕 If the field is truly a blob and really does contain binary data I don't think there's a practical way to replicate it, no.

In this case, BLOB fields are encrypted fields such email or address. I have readonly access to the database, so I can't do any change before get the data, or create a view there

In that case I think your only option is to patch tap-mysql (or create your own version) and enable the tap to do something intelligent with them. 😕 If the fields are encrypted can you do anything with them anyway?

Yes, because I have the decryption key. It seems no sense, but is what it is. Anyway I have similar cases in other database. I figured out that the solution was create my own version, but in that case I don't know if the effort is greater than the result. I have my own plain script version working and we are looking for some more "standard". Thanks!

I did it for oracle, not very helpful but it might show you a way forward