Is not utf 8 encoded как исправить

please help! I am using sqlite3 in ipython notebook to create an SQL database. I think I have successfully created the database, but when I go to look at it I am receiving an encoding UTF8 error. Here is my code:

import sqlite3

conn=sqlite3.connect('example.db')
c=conn.cursor()
c.execute('''DROP TABLE PROFILE''')
c.execute('''CREATE TABLE PROFILE
        ( FIRSTNAME TEXT PRIMARY KEY unique   NOT NULL,
         LASTNAME        TEXT    NOT NULL,
         EMAILADDRESS    TEXT    NOT NULL,
         PASSWORD        TEXT    NOT NULL,
         CURRENTJOBTITLE    TEXT    NOT NULL,
         EDUCATION      TEXT    NOT NULL);''')
conn.close()


conn = sqlite3.connect('example.db')
c = conn.cursor()
conn.execute("INSERT INTO PROFILE (FIRSTNAME, LASTNAME, EMAILADDRESS, PASSWORD, CURRENTJOBTITLE, EDUCATION) 
  VALUES ('SALLYSUE','SUE','SALLYSUE@YAHOO.COM','ABC', 'STUDENT', 'GRAD')");
conn.commit()
conn.close()

This is the end of my Code. When I go to look at the file created ‘example.db’ this is where I see the below error:

Error! C:UsersLastnameCSE801example.db is not UTF-8 encoded
Saving disabled.
See Console for more details

So I am not able to see the table I am creating in SQL.

I googled this and found that people said to put this in my code

import sys
reload(sys)
sys.setdefaultencoding()

Well once I do this and try to rerun my code the code produces nothing. It won’t run the code at all. Does anyone have any suggestions? Thanks!

Jupyter notebook is not encoded in UTF-8: The Cause

If you are seeing an error message stating that a Jupyter notebook is not encoded in UTF-8, it means that the notebook file is not saved in the correct encoding and cannot be displayed correctly.

This can cause issues with special characters and non-Latin scripts, as they may be displayed as garbled text or not displayed at all. To fix this issue, you will need to save the notebook file with the correct encoding and then reopen it in Jupyter. The following steps outline how to do this.

How to fix Jupyter notebook is not encoded in UTF-8

SyntaxError: Non-UTF-8 code starting with 'xcb' in file D:pythonProject1main.py on line 16, but no encoding declared; see https://python.org/dev/peps/pep-0263/ for details

Вот такая у меня ошибка. Как ее исправить? Код такой:

from bs4 import BeautifulSoup
with open('asdasda.html', encoding='utf-8', newline='') as file:
    src = file.read()



soup = BeautifulSoup(src,"lxml")


uusa = soup.find_all(class_ = "breeds-list-i")
print(uusa[1])
for block in uusa:
    u = False
    a = uusa.find(class_ = "breeds-list-i__label")
    if a == "Лежебоки":
        u = True

Сайт вот этот. Я пытался спарсить только те породы кошек которые являются лежебоками

The following problems occur when writing a PKL file with python:
code show as below:

As a result, opening the PKL file found:

The solution is as follows:
1: Open the location of this file (If you don’t know how to find the location of the file, please Baidu by yourself, generally put it in your jupyter file save directory):

2: Open the file in Notepad mode:

3: Save the file as utf-8 encoding format, and then save:

4: Re-opening is such a garbled look, but this is no problem, because the pkl file is originally saved with binary encoding:

5: Open the file with python to see the data: