[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

Change by Serhiy Storchaka : -- type: crash -> behavior ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

Serhiy Storchaka added the comment: It was confirmed that it is an SQLite bug, and it will be fixed in the next SQLite bugfix release. -- resolution: -> third party stage: -> resolved status: open -> closed ___ Python tracker

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

mike bayer added the comment: silly me thinking python devs had better access to SQLite devs :) -- ___ Python tracker ___ ___ Pytho

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

Serhiy Storchaka added the comment: It awaits moderator approval. -- ___ Python tracker ___ ___ Python-bugs-list mailing list Unsub

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

mike bayer added the comment: Hi where did you report it?I don't see it on the mailing list or in their fossil tracker. -- ___ Python tracker ___

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

Serhiy Storchaka added the comment: I have reported a bug to SQLite. Will see an answer. It could be possible to implement a workaround in Python if this behavior will not be fixed. -- nosy: +ghaering ___ Python tracker

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

Serhiy Storchaka added the comment: Seems this is a bug in JSON_EXTRACT. -- ___ Python tracker ___ ___ Python-bugs-list mailing lis

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

Serhiy Storchaka added the comment: sqlite> select JSON_EXTRACT('["t\u00e8\u015b\ud835\udd99"]', '$[0]'); tèś�� -- nosy: +serhiy.storchaka ___ Python tracker ___ __

[issue38749] sqlite3 driver fails on four byte unicode strings coming from JSON_EXTRACT

New submission from mike bayer : When using unicode characters inside of JSON strings, values retrieved via the JSON_EXTRACT SQLite function fail to be decoded by the sqlite3 driver if they include four-byte unicode characters. Version information for my build, which is Fedora 30: Python 3.7.