Re: Deutschland-Stack
luigi scarso <[email protected]>
| Newsgroups | gmane.comp.tex.context |
|---|---|
| Message-ID | <CAG5iGsAfhTwH3p0METpA+n9jxz9WumAY9WcYHup=eqZ_zq0bMw@mail.gmail.com> |
On Mon, 23 Mar 2026 at 10:22, Hans Hagen via ntg-context <[email protected]> wrote: > > > $ sqlite3 -header -csv my_db.db "select * from my_table;" > out.csv > > hm, i need to test that > > .mode ascii is quite flexible https://www.sqlite.org/cli.html#changing_output_formats """ To import data with arbitrary delimiters and no quoting, first set ascii mode (".mode ascii"), then set the field and record delimiters using the ".separator" command. This will suppress dequoting. Upon ".import", the data will be split into fields and records according to the delimiters so specified. """ I think that the ascii mode supports only 8bits value, default ascii Columns/rows delimited by 0x1F and 0x1E With the list mode you can set the .separator for field and record , i.e. sqlite> .separator " ✨ " "🕺\r\n\r\n" is ok. -- luigi ___________________________________________________________________________________ If your question is of interest to others as well, please add an entry to the Wiki! maillist : [email protected] / https://mailman.ntg.nl/mailman3/lists/ntg-context.ntg.nl webpage : https://www.pragma-ade.nl / https://context.aanhet.net (mirror) archive : https://github.com/contextgarden/context wiki : https://wiki.contextgarden.net ___________________________________________________________________________________