Trouble with sqlite

107 views
Skip to first unread message

Mickey Mouse

unread,
Jun 11, 2018, 11:14:32 AM6/11/18
to Django users

I am beginner with Django and I'm using PyCharm IDE. I was watching a tutorial following along when I noticed my sqlite file that comes with Django had a question mark next to it (the guy in the video didnt have that). So I clicked it and it prompted me to associate my sqlite file with a certain file type. To experiment I selected the python(.py) file type. Now when I open up I get an error with corrupt code (or at least that's how it looks to me. The error is "File was loaded in the wrong encoding: 'UTF-8.'

When I click on that error message I am able to select from dozens of different encodings. I'm assuming that's the issue but I don't know for sure. Does anybody have a solution to this issue. Thanks.

Daniel Hepper

unread,
Jun 11, 2018, 11:22:06 AM6/11/18
to django...@googlegroups.com
The SQLite file does not contain any Python code, it contains the database. It is stored in a binary format which you can't look at with a text editor.

You will need a special program to look at the contents of this file, a quick Google search brings up https://sqlitebrowser.org/

Hope that helps,
Daniel



On Mon, Jun 11, 2018 at 5:03 PM, Mickey Mouse <anuppra...@gmail.com> wrote:

I am beginner with Django and I'm using PyCharm IDE. I was watching a tutorial following along when I noticed my sqlite file that comes with Django had a question mark next to it (the guy in the video didnt have that). So I clicked it and it prompted me to associate my sqlite file with a certain file type. To experiment I selected the python(.py) file type. Now when I open up I get an error with corrupt code (or at least that's how it looks to me. The error is "File was loaded in the wrong encoding: 'UTF-8.'

When I click on that error message I am able to select from dozens of different encodings. I'm assuming that's the issue but I don't know for sure. Does anybody have a solution to this issue. Thanks.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/12d4e693-7e03-4053-946a-e9a5a08440b8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages