I think that my problem is in using LIKE expression for non-ascii strings. Database encode is UTF-8. When table data in the "base" column (see my first message for structure) consists of english symbols (ascii) LIKE works correct, but when I'm trying to execute it on strings consists of UTF8 symbols non compatible with ascii it doesn't work. For example, if i'll have column "col1" "col1 LIKE 'asciistring'" and "col1 LIKE '%asciistring%'" will return correct data, but "col1 LIKE 'nonasciistring'" receives all data from the table where length of data in col1 is similar to nonasciistring and "col1 LIKE '%nonasciistring%'" receives all data from the table. If someone knows how to solve it, please hrlp me. -- View this message in context: http://old.nabble.com/Column-as-a-substring-tp26253867p26257688.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
