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.