Hello,
I am using the sqlite-shell-win32-x86-3071700, in WindowsXP SP3
The operation is like the following:
......
F:\>sqlite3.exe 1.db
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table a (b int, c int);
sqlite> insert into a values(11,22);
sqlite> select instr('????????????????', '????') as x from a;
1
sqlite> select instr('????????????????', '????') as x from a;
4
sqlite> select instr('????????????????', '????') as x from a;
0
sqlite> select instr('????????????????', '????') as x from a;
8
......
With all the other querries working fine, the querry "select
instr('????????????????', '????') as x from a;" returns 0 instead of 6!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
