Re: [sqlite] How to input a double num?

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

Re: [sqlite] How to input a double num?

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

Re: [sqlite] How to input a double num?

> 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

Re: [sqlite] How to input a double num?

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"

Re: [sqlite] How to input a double num?

> 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 ___

Re: [sqlite] How to input a double num?

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

Re: [sqlite] How to input a double num?

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

Re: [sqlite] How to input a double num?

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@sqlite.org > Dat

Re: [sqlite] How to input a double num?

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

Re: [sqlite] How to input a double num?

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

Re: [sqlite] How to input a double num?

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.988290112

[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.988290112". With the way of "sqlite3_mprintf()" and "%f", the num is cut to "2123456789012346000.00". How to input the num