Use eclipse to compile a python program that inserts data into the SQLite Database

I encountered the following problems today:

Compiling Python with eclipse and inserting data into the SQLite database always prompts the encoding problem. I set the eclipse workspace to use UTF-8 encoding or not.

But it is written in eclipseProgramIt's strange that I can save and use idle to open it but compile it.

 

I checked all the configurations for possible reasons, including engineering files.

 

Finally, I used xvi32 to open two identical programs (prepared by eclipse and idle respectively) and found the problem.

 

Although the file stored in eclipse is UTF-8 encoded, it does not contain/FF/BB/BF in the file header, while the idle does not have an identifier to recognize UTF-8 (default)

Eclipse does not (maybe it is the reason for my eclipse ~~!)

 

Again, the ID is automatically added for writing with idle, just like saving it with notepad UTF-8.