Re: [sqlite] printf() with UTF-8 and \n \t format

[Tony Papadimitriou]

Great! Didn't think of the char() function at all.  (Although I would prefer 
a platform independent \n)

Thanks.
-----Original Message----- 
From: Keith Medcalf

So, is there any way to advance to next line from a command line
printf()?

sqlite> select printf('%s%s%s', 'line 1', char(10), 'line 2');
line 1
line 2

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users