Re: [sqlite] LIKE operator to support GREEK

Hi Here is the example I worked.. > Creating the table SqlLite.exe test.db "create table t3 (t3key INTEGER PRIMARY KEY,path TEXT,num double,timeEnter DATE , validate BOOL);" > Inserting into the table SqlLite.exe test.db "insert into t3 (path,num) values ('D:/CCVweiew/sampleexample/data/pat

Re: [sqlite] LIKE operator to support GREEK

Gerasimos Xydas <[EMAIL PROTECTED]> writes: > > Hello, > > I have built an SQLite 3 database from C code. > > CASE 1 > ... > CASE 2 > ... > > Best regards, > Gerasimos > Search the newsgroup ... start here http://thread.gmane.org/gmane.comp.db.sqlite.general/42112 Regards,

[sqlite] LIKE operator to support GREEK

Hello, I have built an SQLite 3 database from C code. CASE 1 I tried some sql inserts from my application, in ASCII (Greek codepage). 1. I can "select * from tbl where name='GREEK_NAME';" 2. I can NOT "select * from tbl where name like '%GREEK_CHARACTERS%';" - I am getting no results.