|
|
|
|
|
by groue
1332 days ago
|
|
I do, for JSON columns. I store UTF8 strings in SQLite, so that it is easy to see JSON values with a plain `SELECT *`). And I load blobs, because I code in Swift and the standard JSON decoder eats raw UTF8 memory buffers, not strings. This avoids two useless conversions: - first from a C string loaded from SQLite to a Swift Unicode string (with UTF8 validation). - next from this Swift Unicode string to a UTF8 memory buffer (so that JSONDecoder can do its job). SQLite is smart enough to strip the trailing \0 when you load a blob from a string stored in the database :-) |
|