diff options
| author |  Adam Chlipala <adam@chlipala.net> | 2013-12-03 16:54:04 -0500 |
|---|---|---|
| committer | Adam Chlipala <adam@chlipala.net> | 2013-12-03 16:54:04 -0500 |
| commit | d89fd37a66ab73ea7eba5e2574c4e679c4026f0b (patch) | |
| tree | ae916e054118cec51b56e8eeb0f0a6f1157cb648 /src | |
| parent | abf4da5f80ce9ba5f693aa8fc2493eb28cd8e6f3 (diff) | |
Increase precision for rendering floats to SQL
Diffstat (limited to 'src')
| -rw-r--r-- | src/c/urweb.c | 4 | ||||
| -rw-r--r-- | src/mysql.sml | 2 | ||||
| -rw-r--r-- | src/postgres.sml | 2 | ||||
| -rw-r--r-- | src/sqlite.sml | 2 |
4 files changed, 5 insertions, 5 deletions
diff --git a/src/c/urweb.c b/src/c/urweb.c index 4ff7a218..8bd5ada9 100644 --- a/src/c/urweb.c +++ b/src/c/urweb.c @@ -1622,7 +1622,7 @@ char *uw_Basis_attrifyFloat(uw_context ctx, uw_Basis_float n) { int len; uw_check_heap(ctx, FLOATS_MAX); result = ctx->heap.front; - sprintf(result, "%g%n", n, &len); + sprintf(result, "%.16g%n", n, &len); ctx->heap.front += len+1; return result; } @@ -2406,7 +2406,7 @@ char *uw_Basis_sqlifyIntN(uw_context ctx, uw_Basis_int *n) { return uw_Basis_sqlifyInt(ctx, *n); } -char *uw_sqlfmtFloat = "%g::float8%n"; +char *uw_sqlfmtFloat = "%.16g::float8%n"; char *uw_Basis_sqlifyFloat(uw_context ctx, uw_Basis_float n) { int len; diff --git a/src/mysql.sml b/src/mysql.sml index f708da04..c70a1cdd 100644 --- a/src/mysql.sml +++ b/src/mysql.sml @@ -385,7 +385,7 @@ fun init {dbstring, prepared = ss, tables, views, sequences} = newline, box [string "uw_sqlfmtInt = \"%lld%n\";", newline, - string "uw_sqlfmtFloat = \"%g%n\";", + string "uw_sqlfmtFloat = \"%.16g%n\";", newline, string "uw_Estrings = 0;", newline, diff --git a/src/postgres.sml b/src/postgres.sml index 44101527..41529173 100644 --- a/src/postgres.sml +++ b/src/postgres.sml @@ -376,7 +376,7 @@ fun init {dbstring, prepared = ss, tables, views, sequences} = newline, box [string "uw_sqlfmtInt = \"%lld::int8%n\";", newline, - string "uw_sqlfmtFloat = \"%g::float8%n\";", + string "uw_sqlfmtFloat = \"%.16g::float8%n\";", newline, string "uw_Estrings = 1;", newline, diff --git a/src/sqlite.sml b/src/sqlite.sml index 4ec64788..09c4c683 100644 --- a/src/sqlite.sml +++ b/src/sqlite.sml @@ -160,7 +160,7 @@ fun init {dbstring, prepared = ss, tables, views, sequences} = newline, box [string "uw_sqlfmtInt = \"%lld%n\";", newline, - string "uw_sqlfmtFloat = \"%g%n\";", + string "uw_sqlfmtFloat = \"%.16g%n\";", newline, string "uw_Estrings = 0;", newline, |