Hello! I'm an Android Developer. I converted my tables to FTS3 so as to implement Full Text Search and it helped me. But it came with a demerit is that:
While retrieval, '0' gets truncated after decimal. *eg:* 723.0 or 723.00 will be fetched as 723. *Query fired:* Select * from tableName where myValue MATCH "+search+"; I changed my table to simple sqlite. then 723.0 will be fetched as 723.0 only* Query fired:* Select * from tableName where myValue = '"+search+"'; I request you all, to please let me know where I'm going wrong and how to handle the situation or is it some bug in fts3. Thanks and Regards: Abhi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users