Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Clarify that the legacy_file_format pragma only effects new databases and does not provide information on the file format of the current database. CVSTrac ticket #2804. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
84748f6b9b9db949816ea578814f7816 |
| User & Date: | drh 2007-11-27 23:36:12 |
|
2007-11-28
| ||
| 16:24 | Fix hyperlink errors in the documentation. CVSTrac ticket #2807. (check-in: 10fa1f2eea user: drh tags: trunk) | |
|
2007-11-27
| ||
| 23:36 | Clarify that the legacy_file_format pragma only effects new databases and does not provide information on the file format of the current database. CVSTrac ticket #2804. (check-in: 84748f6b9b user: drh tags: trunk) | |
| 18:42 | Additional website updates associated with version 3.5.3. (check-in: ec178c6e10 user: drh tags: trunk) | |
Changes to pages/pragma.in.
262 263 264 265 266 267 268 269 270 271 272 273 274 275 |
<br>PRAGMA legacy_file_format = <i>ON | OFF</i></b></p>
<p>This pragma sets or queries the value of the legacy_file_format
flag. When this flag is on, new SQLite databases are created in
a file format that is readable and writable by all versions of
SQLite going back to 3.0.0. When the flag is off, new databases
are created using the latest file format which might not be
readable or writable by older versions of SQLite.</p>
<p>This flag only affects newly created databases. It has no
effect on databases that already exist.</p>
</li>
<a name="pragma_locking_mode"></a>
<li><p><b>PRAGMA locking_mode;
|
> > > > > |
262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 |
<br>PRAGMA legacy_file_format = <i>ON | OFF</i></b></p>
<p>This pragma sets or queries the value of the legacy_file_format
flag. When this flag is on, new SQLite databases are created in
a file format that is readable and writable by all versions of
SQLite going back to 3.0.0. When the flag is off, new databases
are created using the latest file format which might not be
readable or writable by older versions of SQLite.</p>
<p>When the pragma is issued with no argument, it returns the
setting of the flag. This pragma does <u>not</u> tell which
file format the current database is using. It tells what format
will be used by any newly created databases.</p>
<p>This flag only affects newly created databases. It has no
effect on databases that already exist.</p>
</li>
<a name="pragma_locking_mode"></a>
<li><p><b>PRAGMA locking_mode;
|