On Fri, 30 Oct 2009 02:47:37 -0700 (PDT), liubin liu
<7101...@sina.com> wrote:
> Thank you!
>
> I mayn't need the high precision like
> "212345678901234567890123456.988290112".
Indeed, you don't. In a previous message you said:
>> The project is on power-measurement. So there
>> are some big nu
Thank you!
I mayn't need the high precision like
"212345678901234567890123456.988290112".
John Crenshaw-2 wrote:
>
>> May I use sqlite3_bind_double() and sqlite3_prepare_v2() to solve the
>> problem.
>
> That won't fix it. Your number is too large to fit in any native data
> type. Even the p
> May I use sqlite3_bind_double() and sqlite3_prepare_v2() to solve the
> problem.
That won't fix it. Your number is too large to fit in any native data
type. Even the plain math inside your own program won't work right,
because the precision of the number is limited at the C level, not the
SQLite
Thanks a lot for every reply.
The num is just random num. The project is on power-measurement. So there
are some big nums with high precision.
May I use sqlite3_bind_double() and sqlite3_prepare_v2() to solve the
problem.
liubin liu wrote:
>
> Now I use the sqlite3_mprintf() and the "%f" to
> He's probably measuring the number of atoms in a city or something.
LOL. Actually my bet is that field of the project has more to do with
number theory. That's the only likely way to get a number that large
with such high precision.
John
___
sqlite-us
On 29 Oct 2009, at 12:38pm, Griggs, Donald wrote:
> Regarding: How to input the num
> "212345678901234567890123456.988290112"?
>
>
> Purely curious, if it's not confidential -- how are you acquiring
> numbers of such precision?
>
> If these are measurements, I'm just awed by the precision the de
Regarding: How to input the num
"212345678901234567890123456.988290112"?
Purely curious, if it's not confidential -- how are you acquiring
numbers of such precision?
If these are measurements, I'm just awed by the precision the device is
achieving. If instead these numbers represent somethin
s fit your needs..
I'm curious, how did you get the number 212345678901234567890123456.988290112 ?
-ic
--- On Wed, 10/28/09, liubin liu <7101...@sina.com> wrote:
> From: liubin liu <7101...@sina.com>
> Subject: [sqlite] How to input a double num?
> To: sqlite-users@sqli
liubin liu wrote:
> Now I use the sqlite3_mprintf() and the "%f" to get the double num. My code
> is below.
>
> Now there is a num like "212345678901234567890123456.988290112". With the
> way of "sqlite3_mprintf()" and "%f", the num is cut to
> "2123456789012346000.00".
>
>
> How to
liubin liu wrote:
> Now I use the sqlite3_mprintf() and the "%f" to get the double num. My code
> is below.
>
> Now there is a num like "212345678901234567890123456.988290112". With the
> way of "sqlite3_mprintf()" and "%f", the num is cut to
> "2123456789012346000.00".
>
>
> How to inp
iubin liu
Sent: Wednesday, October 28, 2009 10:49 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to input a double num?
Now I use the sqlite3_mprintf() and the "%f" to get the double num. My
code
is below.
Now there is a num like "212345678901234567890123456.9882901
Now I use the sqlite3_mprintf() and the "%f" to get the double num. My code
is below.
Now there is a num like "212345678901234567890123456.988290112". With the
way of "sqlite3_mprintf()" and "%f", the num is cut to
"2123456789012346000.00".
How to input the num "21234567890123456789
12 matches
Mail list logo