Which printf? There are a lot of them. Assuming that you mean the SQLite3 built-in function printf() (as in SELECT PRINTF(...);) that function does not interpret backslash escape sequences. Interpretation of such things are a user I/O feature, not a data storage/retrieval feature.
As for the first question, every string in SQLite3 is UTF-8, unless you tell it explicitly that you want one of the UTF-16 formats or use blob (bag-o-bytes) which can be any old bag-o-bytes you happen to like and it is just that, a bag-o-bytes containing just, well, bytes. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Tony Papadimitriou >Sent: Tuesday, 19 December, 2017 11:38 >To: General Discussion of SQLite Database >Subject: [sqlite] printf() with UTF-8 and \n \t format > >A couple of questions about printf > >1. Does it work with UTF-8? If so, how? > >2. Does it understand \n and \t? I put actual line breaks inside the >string which is OK if run from script file but it won’t work with >one-liners on the command-line. > >Thank you >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
