What is it '��' in db.sqlite3?

Question

I am working on Atom Editor on MacOS,

The first few lines in 'db.sqlite':

SQLite format 3@  & :&.���
D�
/O  �X9c��!d��O-�1indexauth_user_groups_user_id_6a12ed8bauth_user_groupsCREATE

How to display the ��?

It looks like database file is corrupted. There are some sqlite GUIs, try to open your database... — Héctor, Oct 31 '17 at 11:11
the database file is not a text file it contains data that the text editor cant read. — mohammedgqudah, Oct 31 '17 at 11:14
If I leave it open, things works well.After I closed it, error occurs. In several django projects I created, the repeated operation incur same errors. @AvinashRaj — AbstProcDo, Oct 31 '17 at 11:15
so, if it is opened by text editor, error unexpected will occurs? @mohammedqudah — AbstProcDo, Oct 31 '17 at 11:21

score 2 · Accepted Answer · edited Oct 31 '17 at 13:19

2

You shouldn't open the db.sqlite file in a text editor, try deleting the file and run

python manage.py migrate

again. It should recreate the db.sqlite file.

edited Oct 31 '17 at 13:19

cezar

answered Oct 31 '17 at 12:20

Samuel Omole

It does not work,`django.db.utils.DatabaseError: database disk image is malformed` – AbstProcDo Oct 31 '17 at 22:47
1

I found someone else who had the same issue...well kinda, you could the solution if it works for u, [https://stackoverflow.com/questions/13675615/svn-cleanup-sqlite-database-disk-image-is-malformed] and if it doesnt work out, you can try creating a new django project in a virtual env and copy your files over to the new project – Samuel Omole Nov 01 '17 at 14:16

What is it '���' in db.sqlite3?