There seems to be bogus data in your database file. Here's a quick test:
> sqlite> .tables
> common general rules symbols
> sqlite> select * from symbols;
> co|n|ന്||0
> vo|a|അ||0
> sqlite> .dump symbols;
> BEGIN TRANSACTION;
> COMMIT;
> .mode insert
> select * from symbols;
> INSERT INTO table VALUES('co','n','ന്','',0);
> INSERT INTO table VALUES('vo','a','അ','',0);
There seem to be non-printable characters in the fourth column.
As you said, this returns no rows:
select * from symbols where pattern = 'n';
However, this gives the expected result:
select * from symbols where pattern like 'n';
So there's something funky with the data you're inserting.
Ah, just read your new post. Seems you've found the error in code. Good :-)
Tom
BareFeetWare
--
Comparison of SQLite GUI tools:
http://www.barefeetware.com/sqlite/compare/?ml
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
