Working with bson in tibble

[Enuma]

Hi,

What is a proper way of dealing with binary json column data from mysql database? I was not able to decode binary json collected from mysql database using json64::j_decode() => Error: is.raw(input) is not TRUE. Both class and typeof insist that the object type is a list. The column in viewer looks like this:

Thanks.

[andresrcs]

To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one:

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[Enuma]

Hi, that is not gonna work. Dunno what the bson contains, so I can't post it freely. At the same time I don't understand its structure hence I am not able to recreate it as reprex. If I would be able to do that, I could as well solve the problem myself. Catch 22 sort of. I wanted to know whether anyone got bson from mysql in this exact format & what did they do with it to decode.
Thanks anyway.