How to fix different encodings in SQlite database?

Question

SQLite

I write text in Russian to the SQLite database. Then I read. Everything works fine.
If you open the database through SQLiteStudio, then the Russian text looks like diamonds.

If you enter a Russian text there, then it looks like krakozyabry in my program.
It turns out that my program writes in UTF-8, and SQLiteStudio in some other format.
How to make Russian text display correctly in SQLiteStudio?

Answer 1

How to make Russian text display correctly in SQLiteStudio?

"It's not me going against the current, this current is going against me!" (C) Film "Give me a book of complaints"
Obviously, someone is setting the encoding incorrectly. And if you choose between a popular application and "Hello word" from a novice coder, then the choice is clearly not in favor of the latter.
Specify your database settings and connection parameters from your script.