On Tue, Jul 23, 2013 at 1:38 PM, Dan Kennedy <danielk1...@gmail.com> wrote:
> On 07/23/2013 02:52 PM, Max Vlasov wrote: > >> ....So >> par adoxically probably the best type for universal field container is >> REAL >> (or NUMERIC) since it will accept data of any type, but has advantage of >> best sorting if reals or integers are involved. >> >> Is this correct or I am missing something? >> > > The only difference between "INTEGER" and "REAL" is that real > values are converted to integers if this is possible without > loss of data. In other respects they are the same. Both try > to convert text values to numbers on insert. > So when building indexes, it doesn't matter whether it's REAL or INTEGER, the comparison will include both real and fractional parts of values if they exist, right? Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users