Hi,
I am using ICU library to collate and pattern match strings in Russian
language. I use C api to intialise the icu library .
sqlite3IcuInit(db);
zSQL = sqlite3_snprintf(1024,temp1,"SELECT icu_load_collation('ru_RU',
'RUSSIAN');");
sqlite3_prepare_v2(db,(const char *)zSQL,-1,&CollationStmt, NULL);
further for Pattern matching-
zSQL = sqlite3_snprintf(1024,temp2,"SELECT * FROM l1 WHERE data LIKE
'марта' ;");
The statement return exactly one matched string.
If I modify the statement to return all strings which match 'м' , No strings
are fetched.
zSQL = sqlite3_snprintf(1024,temp2,"SELECT * FROM l1 WHERE data LIKE 'м'
;");
sqlite3_prepare_v2(db,zSQL,-1,&SelectStmt, NULL);
What could be going wrong ?
-Sreekumar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
