Skip to main content
Stack Overflow
  1. About
  2. For Teams

Return to Revisions

4 of 4
minor spelling and grammar

Python: Can dumpdata cannot loaddata back. UnicodeDecodeError

I have been using Python 2.7, Django 1.5 and PostgreSQL 9.2 for two weeks. Never saw it before. Everything is freshly installed on my Windows 7 machine, so it should have default settings. Django beautifully generates tables in my db. Looks like everything works fine. I am able to dump data from my database by running:

manage.py dumpdata > test.json

or

manage.py dumpdata --indent4 > test.json

I saw that the JSON file it looks as it should.

Then, I truncate some tables and try to load them from the JSON file with:

python manage.py loaddata database = T2 test.json // or without db name

I got the following error:

"UnicodeDecodeError: 'utf8' codec can't decode byte 0xff in position 0: invalid start byte"

If I open the test.json file in notepad, save it as utf8 and try again, then I get:

"No JSON object could be decoded"

The file still looks OK, not empty.

By the way, when I open the JSON file with notepad it offers me to save it as Unicode. My database has UTF8 encoding. Please advise. Thank you.

Elena Kr
  • 171
  • 1
  • 1
  • 5
default

AltStyle によって変換されたページ (->オリジナル) /