-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 06/07/13 01:20, ?????? wrote:
> I am using the sqlite-shell-win32-x86-3071700, in WindowsXP SP3
I did the same queries on Linux and got very different answers that appear
to be correct. I'd suggest using SQLite programmatically since the
Windows console isn't unicode.
SQLite version 3.7.15.2 (APSW 3.7.14.1-r1)
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;
3
sqlite> select instr('????????????????', '????') as x from a;
5
sqlite> select instr('????????????????', '????') as x from a;
7
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iEYEARECAAYFAlHYfTQACgkQmOOfHg372QTYygCfXW3MQtF9tHCnG9/PIHTRwBjt
a8sAnRo2/4DkqjfDfanykDwk0GG9tcIw
=dEpl
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
