Hello, I have a database with a table named "symbols". This has the following schema.
CREATE TABLE symbols (type TEXT, pattern TEXT, value1 TEXT, value2 TEXT, children INTEGER); I am using the C API of Sqlite and my application inserts records into the above table. Everything is executed inside a transaction and if all looks good, application will commit the transaction. 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? Please find the attached the database. Sqlite version - 3.7.4 Any help would be appreciated -- Navaneeth
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
