-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 27/10/12 12:43, Steinar Midtskogen wrote: > But why can't sqlite observe LC_NUMERIC for the output - no ambiguity > would then arise?
Because the SQLite library does not know where the output is going. If you ask for a number to be provided as a string there is no way it can even guess. If you are referring to the shell then it has a similar issue. Is the output going to be read by a program (where being deterministic is good) or by a human (where local conventions matter more)? The rule of thumb is very easy - the people directly using SQLite are developers. Those developers should then take whatever formatting and similar actions are necessary for their end users as appropriate. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlCMTd0ACgkQmOOfHg372QQqxQCfTA1Tw+TRYoeh9aLkzjnPTvcU 5GkAmwU8DagckuXxsrkRY6CthYR/FTFJ =zZ1u -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users