'SQL column type JSON returning invalid characters

I have created a table on my database with a column type JSON, the problem is that when I get that column values on API, some characters doesnt came correctly.

Example:

I am inserting this values:

[
    {
        "nome": "test",
        "email": "test",
    },
    {
        "nome": "André Lopes",
        "email": "[email protected]",
    }
]

But when I receive them on API they came

[
    {
        "nome": "atemphar", 
        "email": "atemphar"
    },
    {
        "nome": "André Lopes", 
        email": "[email protected]"
    }
]

And as you can see the name André, doesnt come with é.

How can I solve this problem, I tried to change collation, but gives me always is not valid character set 'binary'

mysqljson


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions