Skip to content

MySQL JSON field type with string should decode in python3 #272

Open
@howmp

Description

@howmp

Table:

CREATE TABLE test (id int, value json);

With data:

id value
1 {"string1":"string2"}

But event's values in python3 is :

{"id":1,"value":{b"string1":b"string2"}

And when use json.dumps will raise TypeError: keys must be a string

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions