MySql JSON data type not using the correct encoding

Question

I am trying to store json data into a column with JSON data type in MySql.

Here is the table:

    CREATE DATABASE `testutf8` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
USE testutf8;
CREATE TABLE t2(jdoc JSON, sdoc TEXT);
INSERT INTO t2 VALUES('{"key1":"value1", "key2":"value2", "å": "value3"}','{"key1":"value1", "key2":"value2", "å": "value3"}');
SELECT * FROM t2;

However I get this result:

jdoc:
{"Ã¥": "value3", "key1": "value1", "key2": "value2"}    
sdoc:
{"key1":"value1", "key2":"value2", "å": "value3"}

Apparently the column with JSON data type doesn't encode the characters correctly.

How can I fix this?

Thanks in advance :)

How are you storing and retrieving the JSON? Maybe the encoding is wrong at another layer. — shmosel
– shmosel, Commented Jan 6, 2017 at 0:16
@shmosel: The codes above is how I stored and retrieve the JSON. So there is no another layer. — Evan_HZY
– Evan_HZY, Commented Jan 6, 2017 at 0:19

Evan_HZY · Accepted Answer · 2017-01-06 00:30:36Z

1

IntelliJ has encoding issue for JSON data type.

answered Jan 6, 2017 at 0:30

Evan_HZY

1,0446 gold badges19 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySql JSON data type not using the correct encoding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related