character encoding for sqlite database

The documentation states that the file 'zotero.sqlite' is the file that stores the bibliography database. In the (unlikely) even that the database needs to be viewed in another application and zotero is not available, what is the correct character encoding? Tried to view in a text editor. Is there another application that will be able to view the database in human-legible format?
  • edited December 22, 2010
    It is a SQLite 3.x database & not a plain text file. There are multiple tools to allow you to view or dump it into a human-legible format (including the sqlite3 command line client).

This is an old discussion that has not been active in a long time. Instead of commenting here, you should start a new discussion. If you think the content of this discussion is still relevant, you can link to it from your new discussion.