On Fri, Feb 10, 2017 at 2:41 PM, Arjen Markus <arjen.mar...@deltares.nl> wrote:
> > -----Original Message----- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf > > Of Simon Slavin > > Sent: Friday, February 10, 2017 2:36 PM > > To: SQLite mailing list > > Subject: Re: [sqlite] thousand separator for printing large numbers > > > > > > On 10 Feb 2017, at 1:25pm, Arjen Markus <arjen.mar...@deltares.nl> > wrote: > > > > > Not entirely, in German-spoken countries the apostrophe (') is often > used as a > > thousands-separator. > > > > That's Switzerland, right ? Not a member of the EU. I didn't know it > covered other > > countries too. Thanks. > > > > To make it worse still, the ISO standard says we should all be using a > non-breaking > > space, regardless of country. > > > I have seen it in presentations by German speakers (the nationality, not > the language), mostly as an unnoticed mistake or perhaps an automatic > correction by "helpful" presentation software. (Another fun exercise: > collect the various date formats in use in various countries) > You guys are all beside the point! ;) Once you can do select printf("%,d", an_int) which gets you a "hard-coded" 1,234,567, you can always replace(select printf("%,d", an_int), ',', '.') or whatever separator you want (char(160) for non-breakeable space Simon). But right now, you cannot, and have to resort to ugly SQL, which is also less efficient. Thus this post to: 1) ask SQL experts on the best way to emulate thousand-sep in SQL 2) ask DRH to consider enhancing SQLite's built-in printf() to support it out-of-the-box. Thanks, --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
