On Fri, Feb 10, 2017 at 7:40 PM, James K. Lowden <jklow...@schemamania.org> wrote:
> On Fri, 10 Feb 2017 10:46:24 +0100 > Dominique Devienne <ddevie...@gmail.com> wrote: > > > Couldn't SQLite's built-in printf gain a thousand-separator formatting > > argument, which doesn't need to be locale aware or could be even > > explicit after the arg? > ... > > This is data meant to be viewed with any SQLite client, so kind of > > "report". > > What you're really talking about here isn't a printf function in the > SQLite C API, but the printing done by the sqlite3 shell. > I am. Because the view itself calls printf. Same SQL case expression of my original post. > Any standard printf implementation these days supports locale-specific > thousands separators. If SQLite uses sprintf(3) under the hood to > convert floating point values to strings in support of > sqlite3_value_text, it could have access to that support. All it > would need to do is call setlocale(3) in shell.c. > it doesn't. Follow the link from my previous post. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
