legacyFileFormat

Queries or sets the legacy_file_format flag.

When enabled (true), SQLite will create new database files in a format that is compatible with all versions of SQLite back to 3.0.0. When disabled (false, the default), new databases may use a more recent file format that is not readable by older SQLite versions.

This pragma only affects the creation of new database files; it has no effect on existing databases. For maximum compatibility with very old systems, this can be enabled before creating a database. For most modern applications, leaving this disabled is recommended.

See also