Insert from JSON containing strings with non-ascii characters are escaped as unicode for lists, tuples, dicts.

[dylan-wu]

JSON Test File (test.json):

[
    {
        "id": 123,
        "text": "FR Théâtre"
    },
    {
        "id": 223,
        "text": [
            "FR Théâtre"
        ]
    }
]

Command to import:

sqlite-utils insert test.db text test.json --pk=id

Resulting table view from datasette:

Original, db.py line 2225:

        return json.dumps(value, default=repr)

Fix, db.py line 2225:

        return json.dumps(value, default=repr, ensure_ascii=False)