3 ms·
The SQLite command shell supports the format described there. I have also independently used the same format too. But now, they have a name for it, which can be
by zzo38computer 7y ago
The SQLite command shell supports the format described there. I have also independently used the same format too. But now, they have a name for it, which can be useful.
One variant I have sometimes used is DLE to escape the next character if it is a control character that should be part of the data.
- reactorpres 7y agoUnfortunately, I was unable to get the .separator command to accept the control characters. It always threw an error stating that multi-character separators are not allowed. Since those characters are in the regular ASCII table, I wouldn't have thought they were multi-character/byte characters, but maybe sqlite just doesn't allow the use of non-printing characters.
- zzo38computer 7y agoTo use control characters as separators, type: .mode ascii