SQLite short file names 8.3
I am attempting to compile SQLite for an operating system that does not support long file names. The max file name is 8 chars long with an extension of 3 chars (8.3).
Currently a "-journal" is created while using SQLite this breaks the file name rule and stops SQLite with "Disk I/O Error"
I have tried to disable the journal from being created in the first place with "PRAGMA journal_mode OFF" but it appears that the file still gets created then destroyed.
- Is 开发者_运维百科there anyway (compile flag or PRAGMA, ect) to force SQLite to use 8.3 file names?
- Is there anyway to disable the journal from being created?
Not Windows, not Unix, not OS2, other OS
Option 1: Since you need to create a VFS for your "Not Windows, not Unix, not OS2, other OS" you could have its xOpen function translate "name.sdb-joural" into "name.jnl"
Option 2: Modify sqlite3PagerOpen to use a different mechanism, such as changing the file extension, to make the journal name
精彩评论