On the command line:
/ > sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
does work. I know this because if I query for "key500" I get back that
row. It's not blanks either because if I
do:
where name link "key1%"
I only get rows prior to "key199". Very weird. I did try the other
alternatives (single quotes and piping into
sqlite3 test.db) but got the same result.
I'll try changing the varchar to TEXT. See if that makes a difference....
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
