﻿id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
35819	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."	Bug	closed	Core (Management commands)	5.1	Normal	invalid	dumpdata		Unreviewed	0	0	0	0	0	0
