Migration Arabic SQLite to MySQL

Using Django Using the ORM
1

Hi everyone,

I trying to migrate my SQLite DB to MySQL DB.

I am using: python -Xutf8 manage.py dumpdata > data.json

but the word with arabic font, inside data.json, are not written right in arabic but only rubbish !!

Anyway these words are written right inside db.sqlite3 .

Maybe someone can help.

Thank you

2

You can try a few things.

  1. What is your python version? python --version

  2. Try to set UTF-8 Encoding Explicitly before running the dumpdata command:

set PYTHONIOENCODING=utf-8
python -Xutf8 manage.py dumpdata > data.json

Post your results and / or errors here and avoid images.

Good luck!

3

Hi,

thanks for your help. I tried it but it didn’t work !

python --version: Python 3.12.3

Best Regards

Viele Grüße

Sinan Ismael

4

What was the error? Paste here.