Re: [sqlite] Storing large numeric values

2010-01-02 Thread Jay A. Kreibich
On Sat, Jan 02, 2010 at 10:01:42AM +, Simon Slavin scratched on the wall: > > On 2 Jan 2010, at 9:54am, Bert Nelsen wrote: > > > I am trying to save values like 19.000.000.000 to my database but I haven't > > found the appropriate column type yet. Can anybody help please. > > I am using the

Re: [sqlite] Storing large numeric values

2010-01-02 Thread Artur Reilin
Sorting wasn't planned, but it's a nice idea. At least i planned to use Top 5 or Top 10 of the highest values for my little project. So (A) would be the best idea. Math doesn't required at my current point. That's a great format and also easy to read. Thanks Simon. -- Am

Re: [sqlite] Storing large numeric values

2010-01-02 Thread Artur Reilin
According to this I have also a question. I use some values for some gamedata and use the played days, hours, minutes and seconds and put them in one column. I use . as an seperator. Does it still is an integer or do i need to change the column type to text or blob? Using 4 columns - one

Re: [sqlite] Storing large numeric values

2010-01-02 Thread Simon Slavin
On 2 Jan 2010, at 9:54am, Bert Nelsen wrote: > I am trying to save values like 19.000.000.000 to my database but I haven't > found the appropriate column type yet. Can anybody help please. > I am using the dhRichClient command object, but even Int64 isn't large > enough. There are only five

[sqlite] Storing large numeric values

2010-01-02 Thread Bert Nelsen
I am trying to save values like 19.000.000.000 to my database but I haven't found the appropriate column type yet. Can anybody help please. I am using the dhRichClient command object, but even Int64 isn't large enough. ___ sqlite-users mailing list