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 02.01.2010, 11:55 Uhr, schrieb Simon Slavin <slav...@bigfraud.org>: > > On 2 Jan 2010, at 10:11am, Artur Reilin wrote: > >> 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? > > Any text with two '.'s in is not an integer. Integers do not have > decimal points in. So it was probably storing those as TEXT. If you do > want to store such a value in sortable form you have two simple options: > > A) Use a fixed-lenght format like DDDHHMMSS and store it as TEXT. > B) Calculate all values as seconds and store the number as seconds as an > INTEGER. > > (A) makes it easy to format for printing and (B) makes it easy to do > maths. If, however, you don't care about sorting, indexing or maths > there's no reason why you shouldn't continue to do it as you already do > it. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
