On 16 Jan 2011, at 2:55pm, Navaneeth.K.N wrote: > Now after the DB file has been created, "select * from symbols;" shows > all the records available. Consider I have patterns like "n" & "a". A > select statement like "select * from symbols where pattern = 'n'" > returns no records. Same thing happens if I do "select * from symbols > where pattern = 'a'". But when I do "select * from symbols where > pattern like 'n'" it returns the matching records. I am wondering why > this is happening?
You've probably used the wrong form of quotes somewhere and either your database fields or your SELECT has the n with some form of quote marks around it. Try using the command-line tool with exactly this request: select * from symbols where pattern = 'n' If that gets no results do just select pattern from symbols and see if it shows some form of quote marks around the contents of the 'pattern' column. > Please find the attached the database. This mailing list does not allow attachments: most of the people who read it won't read most of the messages. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
