sqlite3.ProgrammingError while python manage.py dumpdata > dump.json

[DragonwolfAside]

Python 3.12.4 Django 5.1.1

Having difficulty while dumping sql data with pipes

C:\Users\Admin\Desktop\Projects\django-project>python manage.py dumpdata > dump.json
CommandError: Unable to serialize database: 'gbk' codec can't encode character '\xa0' in position 70: illegal multibyte sequence
Exception ignored in: <generator object cursor_iter at 0x000001FA8E382020>
Traceback (most recent call last):
  File "C:\Users\Admin\AppData\Local\Programs\Python\Python312\Lib\site-packages\django\db\models\sql\compiler.py", line 2115, in cursor_iter
    cursor.close()
sqlite3.ProgrammingError: Cannot operate on a closed database.

but following command runs well

C:\Users\Admin\Desktop\Projects\django-project>python manage.py dumpdata

[{"model": "admin.logentry", "pk": 1, "fields": {"action_time": "2024-10-06T20:31:44.362", "user": 1, "content_type": 6, "object_id": "1", ...

chcp 65001 also didn't work, perhaps Chinese language system make the default encoding to gbk, leading to a serialize error, then the cursor closes.

[Simon Charette]

It appears has more to with your shell environment than Django itself; you most likely have an improper locale defined.

In doubt use utf-8 but how this can be accomplished should be discussed here as this ticket tracker is meant to track issues with Django itself.

TicketClosingReasons/UseSupportChannels