encoding

Queries or sets the text encoding for the main database.

This pragma controls how text data is stored. The possible values are UTF-8, UTF-16le (little-endian), and UTF-16be (big-endian). It is not possible to change the encoding of an existing database. The encoding pragma must be set before any tables are created, and it will only affect the main database.

The default encoding is UTF-8.

See also