See section 3.0 http://www.sqlite.org/datatypes.html
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fitter Man Sent: Friday, March 13, 2009 11:10 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] WHERE clause doesn't seem to work right @John: Is that documented anywhere? I ask because there are some cases I'd like to understand better without going through a lot of testing to determine how it works. I'm inferring from your example the rule is all numerics come first, with integer and floats interleaved according to their numeric sequence, and the remaining values would be treated as strings and sorted accordingly. (Null values get stuck somewhere: I think MySQL puts them at the beginning, but again I'll have to fiddle with this to figure it out, hence my request for a document reference.) Thanks for the prompt reply. -- View this message in context: http://www.nabble.com/WHERE-clause-doesn%27t-seem-to-work-right-tp22497543p22498479.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ 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
