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
