SQLite Forum

How to decode an sqlite 3 file that has Russian text?
Login
> No matter what sort of text encoding I choose in, say, Notepad+, it doesn't display the Russian (Cyrillic) characters.

Are you opening the database in notepad+? If so, that's the problem: the db is a binary file and a text editor won't be able to make any sense of it.

Have you tried something like:

```
echo .dump | sqlite3 THE_DBFILE > mydb.sql
```

(Or the equivalent for your platform.)

And then opening the resulting SQL file (as opposed to database file) in notepad+?